topic Re: How to compare 2 or more qvd files with same data? in QlikView

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

PoojaNarke — Fri, 15 Nov 2024 23:31:20 GMT

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.

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

Miguel_Angel_Baeyens — Wed, 09 Dec 2020 14:46:39 GMT

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/InterRecordFunctions/Exists.htm

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

Nocto — Mon, 21 Dec 2020 20:34:50 GMT

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