Comparing two qvd file

[#1]

How will I be able to get values from a qvd file which are not available when compared to other qvd. For example I have Contract Account and Document Number in a qvd file (qvd1). I want to get all those Document Numbers from qvd2 that were not in qvd1. Thank you in advance.

[jagan]

Hi,

Try like this

Table1:

LOAD

     ContractAccount,

     DocumentNumber

FROM FileName1.QVD;

Table2:

LOAD

     ContractAccount,

     DocumentNumber

FROM FileName1.QVD

WHERE NOT EXISTS(DocumentNumber);

Hope this helps you.

Regards,

Jagan.

[#3]

I tried this but it did not work. Here's what I actually did.

Table1:
LOAD
    VKONT,
OPBEL
FROM test.qvd;

 
Table2:
LOAD
    trim(right(VKONTHist,8)) as VKONT,
OPBELHist as OPBEL,
FROM test2.qvd WHERE NOT EXISTS(OPBEL);

[jagan]

Hi,

Try renaming OPBELHist as OPBEL in the QVD itself and then do the same.

Regards,

Jagan.

[#5]

Hi Jagan,

I tried what you suggested but it still did not work.

Heres what I'm trying to do.

QVD1		QVD2
CONTACCT	DOCNUM	CONTACCT	DOCNUM
1	a	1	a
	b	2	c
2	c	3	e
3	d
	e

I just want to get only docnum B and D since it is not in QVD2. Thank you in advance.

[jagan · Accepted solution]

Hi,

Please check the attached file for solution.

Hope this helps you.

Regards,

Jagan.

[#7]

You should do it like this:

Table1:
LOAD
VKONT,
OPBEL
FROM test.qvd;

Table2:
LOAD
trim(right(VKONTHist,8)) as VKONT,
OPBELHist as OPBEL,
FROM test2.qvd WHERE NOT EXISTS(OPBEL,OPBELHist );

I added a secon parameter to the exist function. Since when you try for the existens you dont have OPBEL in test2.qvd.

[#8]

Hi Jagan and Hansiola,

It did work. Thank you very much for the help.

Regards,

JC