Compare 2 qvd files

[Alf]

There are 2 qvd files (QF1,QF2), both with ID field as  primary key.  I want to know how many ID values are in:

> QF1 that are not in QF2 (QF1 - QF2)
> QF1 and QF2 (QF1 ^ QF2)
> QF2 that are not in QF1 (QF2 - QF1)

I would appreciate any help in this regard.

Greetings, ALF.

[manoranjan_d · Accepted solution]

While loading ur data use the wher cond

QF1 that are not in QF2 (QF1 - QF2)

Use where not exist(primary key)

QF1 and QF2 (QF1 ^ QF2)

Use where  exist(primary key)

QF2 that are not in QF1 (QF2 - QF1)

Use where not exist(primary key)