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?
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.
LOAD ... From...;
LEft Join ....
NoConcatenate LOAD * Resident tmpTable;
DROP Table tmpTable;
View solution in original post