topic Look into tables and find Unique Values in QlikView

Look into tables and find Unique Values

qlikwiz123 — Sat, 16 Nov 2024 18:40:44 GMT

I have

Table A

Table B

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 — Thu, 07 May 2020 20:49:25 GMT

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 ] ;