Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Community,
I am relatively new to Qlik and was looking for some hep with comparing data of two or more qvd files with same fields and same data.
I want to have some flag which shows the un-matching values/records as an output of the comparison.
Try Somenthing like that: the &'|' & is to generate a composite key or lets say a unique key which chains all Field together:
QUALIFY*;
[Table1]:
LOAD [Field1] &'|' &
[Field2]&'|' &
[Field3]&'|' &
as Key1
FROM Source1;
[Table2]:
NoConcatenate
LOAD [Field1] &'|' &
[Field2]&'|' &
[Field3]&'|' &
as Key2
FROM Source2;
[CheckData]:
NoConcatenate
LOAD *,
if(Exists([Table1.Key1],[Table2.Key2]), 'Yes','No') as DataCheck
resident [Table2];