Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Test1:
Load CATG_ID, OtherFields From TABLE1.QVD (QVD);
join
Load CATG_ID, OtherFields From TABLE2.QVD (QVD);
Test2:
Noconcatenate Load * Resident Test1 Where YourCondition;
Alternatively for many cases you could use mapping with applymap() to build your tables.
- Marcus
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
Test1:
Load CATG_ID, OtherFields From TABLE1.QVD (QVD);
join
Load CATG_ID, OtherFields From TABLE2.QVD (QVD);
Test2:
Noconcatenate Load * Resident Test1 Where YourCondition;
Alternatively for many cases you could use mapping with applymap() to build your tables.
- Marcus
Hi,
Try this,
TEST:
Load CATG_ID,
....
From TABLE1.QVD (QVD);
join
Load CATG_ID,
.....
From TABLE2.QVD (QVD);
FINAL_TEST:
Load * Resident TEST
Where QTCONSUMO>=INICIO AND QTCONSUMO<=FIM;
DROP TABLE FINAL_TEST;
Regards
Thanks max!
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!