0 Replies Latest reply: Oct 31, 2018 4:29 AM by Manu Prakash RSS

    How to join two CrossTables with different statement

    Manu Prakash

      Hi,

       

      How to join two cross tables with different statement for Ex:

       

      Table1:

      CrossTable (Questions,Statement,13)

      LOAD

         customer id;

         age;

         gender;

         occupation;

         Month;

           ex: [Q1]

           ex: [Q2]

           ex: [Q3]

           ex: [Q4]

           ex: [Q5]

       

      FROM [lib://Unpivot /sample.xlsx]

      (ooxml, embedded labels, table is Data);

       

      Table2:

      CrossTable (Channel,Channel_Name,13)

      LOAD

         customer id;

         age;

         gender;

         occupation;

         Month;

           ex: [R1]

           ex: [R2]

           ex: [R3]

           ex: [R4]

           ex: [R5]

       

      FROM [lib://Unpivot /sample.xlsx]

      (ooxml, embedded labels, table is Data);

       

      how to join this two crosstables in load editor can anyone please help me on this.