Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Sorry for the basic question but this is not working:
FactTable:
Load A,B,C;
SELECT ... FROM Table1;
CONCATENATE (FactTable)
Load A,B;
SELECT ... FROM Table2;
LEFT JOIN
LOAD A,C;
SELECT ... FROM SubTable;
The LEFT join is workinf fine, if I run it alone Table2 and Subtable, column C is fine.
So I was expecting Field C from Subtable to concatenate on FactTable,it returns NULL
Any tip on what am I doing wrong?
Thanks
Try doing the JOIN of your tables Table2 and SubTable in your SQL SELECT part (single LOAD statement so to say).
I think I know why it doesn't work...
FactTable:
Load A,B,C;
SELECT ... FROM Table1;
CONCATENATE (FactTable)
Load A,B;
SELECT ... FROM Table2;
--> result is a table with Fields A,B,C, even if some C - Fields are null().
LEFT JOIN
LOAD A,C;
SELECT ... FROM SubTable;
will only work, if A and C match --> Synthetic Key!!!
--> solution could be the following:
FactTable:
Load A,B;
SELECT ... FROM Table2;
LEFT JOIN
LOAD A,C;
SELECT ... FROM SubTable;
CONCATENATE (FactTable)
Load A,B,C;
SELECT ... FROM Table1;
--> first join (only A as Key), then concatenate the rest.
You could even remove
CONCATENATE (FactTable)
because if all names are the same, QlikView will do an implicit concatenate.