Using Qualify with Left Join in Load Script - Only applies to top table

[mcowley]

Hey friends,

I'm using qualify to create a flattened table (ENTITY_FINAL_STAGE), but when doing multiple left joins Qlik is not qualifying with the new table name, but the original source table name.

How can i generate a table where all fields have the ENTITY_FINAL_STAGE. prefix?

(see attached)

Much Thanks, 

Matt

[rubenmarin · Accepted solution]

Hi, before the Qualify you can load a temporary table doing all the required joins, the add the Qualify and add a "NoConcatenate LOAD" off all fields.

tmpTable:
LOAD ...  From...;
LEft Join ....

Qualify *;
Unqualify KEY;

FinalTable:
NoConcatenate LOAD * Resident tmpTable;

DROP Table tmpTable;
Unqualify *;