1 Reply Latest reply: Nov 8, 2018 9:04 AM by Juraj Misina RSS

    Load skript Value instead of load value

    Christian Seger

      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

        • Re: Load skript Value instead of load value
          Juraj Misina

          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