Discussion Board for collaboration on QlikView Scripting.
I have two resident tables sa A and B both having student_id field as common.
I need to devise a load statement to create a table C such as
WHERE student_id in
just like we use in select statements like -- select * from table A where student_id in (select student_id from table B)
I know that the above code is wrong and ofcourse it is not working.
Please help me to find a solution for my requirement.
Go to Solution.
I'd do as follows:
B:LOAD student_idFROM FileB.qvd (qvd); // or whatever the sourceA:LOAD *FROM FileA.qvd (qvd)WHERE Exists(student_id); // will load only records where student_id is in table BDROP TABLE B;
FROM FileB.qvd (qvd); // or whatever the source
FROM FileA.qvd (qvd)
WHERE Exists(student_id); // will load only records where student_id is in table B
DROP TABLE B;
Hope that helps.
Use INNER JOIN like:
Just like Miguel said, doing as he mention you get one more advantage... all LOAD statements are optimezed.