4 Replies Latest reply: Nov 23, 2017 1:02 PM by Андрей Шепель RSS

    Keep dual number values

    Андрей Шепель

      Hi, community!

      Do anyone had practice how to save second part (number) of dual values in the script after several data transformation?

       

      For example, in first step i define dual values using excel source:

       

      Temp:

      LOAD

      if(Name='A-1', dual('A-1',1),

      if(Name='B-2', dual('B-2',2),

      if(Name='C-56', dual('C-56',3),

      if(Name='D-44', dual('D-44',4))))) as Name

       

      FROM

      Dual.xlsx

      (ooxml, embedded labels, table is Sheet1);

       

      First result is ok:

      Dual_1.jpg

      But after some data transformation dual sorting is missing in the result:

       

      Result:

      NoConcatenate

      load

      if(Name='D-44', 'Last' & Name,

      subfield(Name,'-',-1)) as Name

       

      Resident Temp;

      DROP Table Temp;

      Dual_2.jpg

       

      Any idea how to keep number dual values in this case?

       

      Thanks.