Discussion Board for collaboration related to QlikView Deployment.
I have 3 tables, A, B and C. I need to make in Load Script an union between B and C and then a join with A. how can I do?
I tried in this way (it doesn't work):
Load * from A;
Load * from B;
Load * from C;
Tables B and C have the same columns.
Thank you so much
Go to Solution.
you can change your join type accordingly
Load * from C
where not exists(key coloumn);
when you joined A and B , B ceases to exist and it is now part of table A that is why concatenate didn't work
Two thing you can try
try using keep and see if it works for you and suitable for your requirement