topic Compare keys from two tables in QlikView

Compare keys from two tables

ashish_2511 — Wed, 25 Nov 2020 16:16:04 GMT

Dear Community -

Here's the problem I'm facing -

I've two tables, Tab1 and Tab2 like this -

Tab1	Tab2
%Key1	%Key2
A	X
B	Y
C	Z

Tab1 is loaded first, when loading Tab2 I've to make sure %Key2 doesn't match any of %Key1. In other words, I've to load all those rows from Tab2 which are not in Tab1

Please Note - %Key1 and %Key2 are composite keys formed out of same fields from both tables.

Any help would be appreciated.

Thanks in advance

-Sneh

Re: Compare keys from two tables

Anonymous — Mon, 10 Apr 2017 09:58:32 GMT

Tab2:

LOAD

...

where not exists(%KEY1,YourKey2CompositionExpression);

could be that you have to put the parameters into '...'

Re: Compare keys from two tables

el_aprendiz111 — Mon, 10 Apr 2017 14:46:31 GMT

hi,

1 example

TABLE1:
LOAD * Inline
[
%Key,value
A,1
B,2
C,3
];

PRM:
LOAD Concat(chr(39) & [%Key] & chr(39),',') AS PARAM Resident TABLE1;
LET v_Param = Peek('PARAM');

TABLE2:
LOAD * Inline
[
%Key,value
X,11
Y,22
Z,33
A,1
]
Where not wildMatch([%Key], $(v_Param))
;

TRACE ...... $(v_Param);

DROP Table PRM;
EXIT Script;