Goran Jakimovski
04/25/2025, 6:48 AMJulius Kos
04/25/2025, 8:32 AMJulius Kos
04/25/2025, 9:07 AMstatus_id = 1
to status_label = 'Active'
. You would then load this table as a separate dataset in the LDM and create a relationship from your main table’s status
column to the lookup table’s status_id
. This way, the descriptive label (status_label
) is defined only once and can be reused for different datasets without duplicating it. However, you would need to test this approach to make sure it fits your data structure and performance needs. Let me know if you wish me to create a product feedback on your behalf regarding ENUM type.Goran Jakimovski
04/25/2025, 10:19 AM