topic Re: Compare fields from multiple tables in QlikView

Compare fields from multiple tables

qlikwiz123 — Sat, 16 Nov 2024 00:11:26 GMT

I have tables as shown (First row is table name)

Limited

Full Table

Alternate Table

ID2

I need to check if ID2 has any matching values in Full Table 'ID' and if it does, then check if ID2 matches with any Limited table 'ID'

In simple case,

if(Alternate Table ID2 = Full Table ID, then check

if(Alternate Table ID2= Limited 'ID', then 'Yes','No') in the script.

How do I achieve this in the script?

jwjackso — Wed, 05 Aug 2020 20:37:43 GMT

If you are adding this Yes/No flag to the [Alternate Table].

mapLimitedID:

mapping

load ID,

'1' as IDFlag

Resident [Limited];

mapFullTableID:

mapping

load ID,

'1' as IDFlag

Resident [Full Table];

[Alternate Table]:

load ID2

If(ApplyMap('mapFullTableID',ID2,'0') = '1',

If(ApplyMap('mapLimitedID',ID2,'0') - '1','YES','No'),'No')

From AlternateTableSource;

qlikwiz123 — Fri, 07 Aug 2020 00:45:46 GMT

Thank You