Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with joins

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;

1 Solution

Accepted Solutions
miguelbraga
Specialist III
Specialist III

Hi there,

Try something like this:

Table2:

LOAD a, b, c from table2.csv;

left join

LOAD a, d, e from table3.csv;

Table3:

LOAD a, b, c from table4.csv;

left join

LOAD a, d, e from table5.csv;

Concatenate

Table1:

LOAD a, b, c, d, e from table1.csv;

FinalTable:

NoConcatenate

LOAD * Resident Table2;

left join (FinalTable)

LOAD * Resident Table3;

Drop Table Table2;

Drop Table Table3;

Rename Table FinalTable to Table;

Hope this helps you

Regards,

MB

View solution in original post

3 Replies
ichimiike
Partner
Partner

Rather than hoping for the tables to 'auto-concatenate', why not force them to yourself?

Table1:

LOAD a, b, c, d, e from table1.csv

concatenate (Table1)

LOAD a, b, c from table2.csv

concatenate (Table1)

LOAD a, d, e from table3.csv

concatenate (Table1)

LOAD a, b, c from table4.csv

concatenate (Table1)

LOAD a, d, e from table5.csv

Hope this helps,

Mat

miguelbraga
Specialist III
Specialist III

Hi there,

Try something like this:

Table2:

LOAD a, b, c from table2.csv;

left join

LOAD a, d, e from table3.csv;

Table3:

LOAD a, b, c from table4.csv;

left join

LOAD a, d, e from table5.csv;

Concatenate

Table1:

LOAD a, b, c, d, e from table1.csv;

FinalTable:

NoConcatenate

LOAD * Resident Table2;

left join (FinalTable)

LOAD * Resident Table3;

Drop Table Table2;

Drop Table Table3;

Rename Table FinalTable to Table;

Hope this helps you

Regards,

MB

Not applicable
Author

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!