Discussion Board for collaboration related to QlikView App Development.
I want to translate this sql below to qlikview extracting the data from these two qvds: TABLE1.QVD and TABLE2.QVD
I know i can use left join, but the problem is that the "where" condition uses fields from both qvds.
Anyone help me?
Complex where-conditions are difficult to impossible but you could use a multi-step method with load + join and in a second step make the where-condition
Load CATG_ID, OtherFields From TABLE1.QVD (QVD);
Load CATG_ID, OtherFields From TABLE2.QVD (QVD);
Noconcatenate Load * Resident Test1 Where YourCondition;
Alternatively for many cases you could use mapping with applymap() to build your tables.
View solution in original post
From TABLE1.QVD (QVD);
From TABLE2.QVD (QVD);
Load * Resident TEST
Where QTCONSUMO>=INICIO AND QTCONSUMO<=FIM;
DROP TABLE FINAL_TEST;
but your way didnt work, because the FINAL_TEST table doesn't exist. So i have to use NOCONCATENATE to force qlikview doesn't mix tables.
Thanks Marcus! Noconcatenate solved my question!