topic Concatenate joined tables in QlikView

Concatenate joined tables

Mon, 19 Mar 2012 16:24:02 GMT

Hi All,

in the below code how can I concatenate joined Residents of Table_2 and Table_3 with Table_1? When I leave it as it is now values from Resident Table_3 won't joined.

Table_1:
SELECT Dim_1, Dim_2, Dim_3 FROM Table_1
Table_2:
SELECT Dim_1. Dim_2 FROM Table_2
Table_3:
SELECT Dim_1, Dim_3 FROM Table_3
Conctenate(Table_1)
LOAD Dim_1, Dim_2 FROM Resident Table_2 Left Join (Table_2) LOAD Dim_1, Dim_3 FROM Resident Table_3
DROP TABLES Table_2, Table_3;

Regards,

Przemek

Re: Concatenate joined tables

hic — Mon, 19 Mar 2012 17:00:46 GMT

You can't do both a join and a concatenation in one statement.

Try the following instead:

TempTable:

LOAD Dim_1, Dim_2 Resident Table_2;

Left Join LOAD Dim_1, Dim_3 Resident Table_3;

Conctenate(Table_1)

LOAD * Resident TempTable;

DROP TABLES Table_2, Table_3, TempTable;

Concatenate joined tables

Mon, 19 Mar 2012 19:28:53 GMT

I did the job, thank you Henric.