Discussion Board for collaboration on QlikView Scripting.
I have two tables with all the same field names:
Table A has 28000 records (QVD)
Table B has 100,000 records (SQL Server Table)
I am loading Table A first and want to combine Table B with Table A.
While combining the TABLE A and TABLE B i want to keep all records from TABLE A but exclude the same records from TABLE B based on MEMBERID.
Usually we use union in SQL.. How can we achieve the simliar result while loading in QLikView.
Go to Solution.
Hello, you can use the EXISTS function.
First you read the first table (TABLE_A).
Creates an additional field identifier for this table: (MEMBERID_A).
Then makes the union between tables using concatenate.
In the filter of your second table, just add the following filter:
WHERE NOT EXISTS (MEMBERID_A, MEMBERID)
MEMBERID AS MEMBERID_A,
// DON't USE THE FIELD CREATED (MEMBERID_A)
WHERE NOT EXISTS(MEMBERID_A, MEMBERID);
you can use
hope this helps
If i use join I see duplicate records for members present in Table A.