Look into tables and find Unique Values

[qlikwiz123]

I have

Table A

ID

Table B

ID

I need to check for IDs in TableA and create a Flag where if ID from Table B is present in Table A, then 'Existing', if not 'New'.

How do I do this?

[Saravanan_Desingh · Accepted solution]

One solution.

tab1:
Mapping
LOAD *, 'Exisitng' INLINE [
    F1
    123
    456
    789
];

tab2:
LOAD *, ApplyMap('tab1',F1,'New') As Flag INLINE [
    F1
    123
    456
    789
    901
    112
    113
]
;