Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mcowley
Contributor II
Contributor II

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

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

1 Solution

Accepted Solutions
rubenmarin

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 *;

View solution in original post

1 Reply
rubenmarin

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 *;