Lists of possible values
Edalitics allows you to define lists of possible values. This often makes sense in environments with complex data models and tables that are reused to normalize certain concepts. For example, we have a customer table with two fields: one for the city of residence and the other for the shipping city. Instead of having the city values in the customer table, we have a master city table that serves this purpose.
At the model level, we can hover over the city field and specify that its values come from the table of possible values. This is done with the “Add table of possible values” button.
This will open a dialog where we specify the table where we have the list of possible values. We specify which field contains the ID that will allow us to join with the original table, and which field we will use to obtain the descriptions.
From that moment on, when I select the “city of residence” field, edalitics will search the table with the city master and show us the city name instead of the code stored in the customer table.