Load skript Value instead of load value

[segerchr]

Hey,

i am searching for a function which can do the following for me:

load

ACB.Name,

ACB.Number --> (if Number 1 is loaded, please write One in the database, if Number 2 is loaded please write Two.

from Sheet

Maybe somebody could help. Thanks in advance. CS

[juraj_misina · Accepted solution]

Hi,

the only way I can think of is using a reference table which you would join or map to your source table:

Map_NumString:
Mapping LOAD * Inline [
   Num, String
   1, One
   2, Two
   3, Three
];

Table1:
LOAD
   ACB.Name,
   ApplyMap('Map_NumString', ACB.Number)     as NumberString
from Source;

Hope this helps.

Juraj