This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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;
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
View solution in original post
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!