Discussion board where members can get started with Qlik Sense.
Hi Everyone, I've got 5 tables. One complete table, two summary tables, and two detail tables. I'd like to get these all into one table.
Table 1 has columns A B C D E
Table 2 (summary data) has columns A B C
Table 3 (detail data) has columns A D E
Table 4 (summary data) has columns A B C
Table 5 (details data) has columns A D E
I tried the code below thinking that they would auto-concatenate, but they did not. Is there a solution for this?
LOAD a, b, c from table2.csv;
join LOAD a, d, e from table3.csv;
LOAD a, b, c from table4.csv;
join LOAD a, d, e from table5.csv;
LOAD a, b, c, d, e from table1.csv;
Go to Solution.
Try something like this:
LOAD a, d, e from table3.csv;
LOAD a, d, e from table5.csv;
LOAD * Resident Table2;
left join (FinalTable)
LOAD * Resident Table3;
Drop Table Table2;
Drop Table Table3;
Rename Table FinalTable to Table;
Hope this helps you
Rather than hoping for the tables to 'auto-concatenate', why not force them to yourself?
LOAD a, b, c, d, e from table1.csv
LOAD a, b, c from table2.csv
LOAD a, d, e from table3.csv
LOAD a, b, c from table4.csv
LOAD a, d, e from table5.csv
Hope this helps,
This is exactly what I needed! I actually concatenated the tables in the Final Table section rather than left joining but other than that this was perfect. Thanks so much for the help!