Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sanjujeeboy
Creator
Creator

exclude common records

i have a Table A having 100 ID,

Table B is having 20 ID

my requirement is Table C which should not have 20 ID from Table B

how to acheive this?

10 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Your latest comment makes your requirement a bit more clear.

How about this:

MapTableB:

MAPPING LOAD ID, false() as Flag RESIDENT TableB;

TableA:

LOAD * FROM TableA-Source (options)

WHERE ApplyMap('MapTableB', ID, true());

This will load all rows from the TableA data source except those presejnt in TableB (without loading TableB). If TableA is already present in your data model, transfer it to a new RESIDENT table using this technique, drop the first TableA and rename the second table to TableA.