1 Reply Latest reply: Nov 12, 2015 4:17 PM by Sunny Talwar RSS

    Error with Apply map and concatenate

      Hello,

      I want to do Applymap with a table that it's concatenated with another. Is it possible? how can i do?



      (I need to concatenate WID with table2, and I need to do applymap with WID and SID in Table1)

      Thank you!


      Table1:
      LOAD Type_T AS Type_T_D99,
      EM as EM_D,
      SID,
      ApplyMap('Table2',SID_D99,'Desconocido') as WID_K99;
      SQL SELECT *
      FROM "BD1.1";



      Table2:
      mapping LOAD SID as SID_D99,
      WID as WID_K99;
      SQL SELECT *
      FROM "BD1.2";


      concatenate(Table2)
      LOAD WID as WID_K99;
      SQL SELECT *
      FROM "BD1.3";

        • Re: Error with Apply map and concatenate
          Sunny Talwar

          May be this:

           

          Table2:
          LOAD SID as SID_D99,
          WID as WID_K99;
          SQL SELECT *
          FROM "BD1.2";


          Concatenate(Table2)
          LOAD SID_D99 //you need this field as well, other wise the WID_K99 won't be mapped

                    WID as WID_K99;

          SQL SELECT *
          FROM "BD1.3";


          Table3:

          Mapping

          LOAD SID_D99,

                    WID_K99

          Resident Table2;


          DROP Table Table2;

           

          Table1:
          LOAD Type_T AS Type_T_D99,
          EM as EM_D,
          SID,
          ApplyMap('Table3',SID_D99,'Desconocido') as WID_K99;
          SQL SELECT *

          FROM "BD1.1";