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
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
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 *;