i am searching for a function which can do the following for me:
ACB.Number --> (if Number 1 is loaded, please write One in the database, if Number 2 is loaded please write Two.
Maybe somebody could help. Thanks in advance. CS
the only way I can think of is using a reference table which you would join or map to your source table:
Mapping LOAD * Inline [
ApplyMap('Map_NumString', ACB.Number) as NumberString
Hope this helps.
Retrieving data ...