I know it is feasible via script but I'd like to know if we can do it at design using expression.
I have the following table. Column "Detail per day" is displayed in the interface. Is there a way to obtain the corresponding _choiceID when a value is selected in "Detail per day" ?
I heard about mapping table, but does it allow 3 columns instead of 2 as typical example ?
LOAD * INLINE [
_Language, "Detail per day", _choiceID
Français, oui, 'Y'
Français, non, 'N'
Deutsch, ja, 'Y'
Deutsch, nein, 'N'
English, yes, 'Y'
English, no, 'N'