How to compare 2 or more qvd files with same data?

[PoojaNarke]

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.

[Miguel_Angel_Baeyens]

I would explore the use of the Exists() function in the script: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Inter...

[Nocto]

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