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.