topic Comparing two qvd file in QlikView

Comparing two qvd file

Wed, 11 Apr 2012 05:46:37 GMT

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.

Comparing two qvd file

jagan — Wed, 11 Apr 2012 06:02:13 GMT

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.

Comparing two qvd file

Wed, 11 Apr 2012 06:18:48 GMT

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

Comparing two qvd file

jagan — Wed, 11 Apr 2012 06:26:05 GMT

Hi,

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

Regards,

Jagan.

Comparing two qvd file

Thu, 12 Apr 2012 09:44:26 GMT

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.

Re: Comparing two qvd file

jagan — Thu, 12 Apr 2012 10:18:26 GMT

Hi,

Please check the attached file for solution.

Hope this helps you.

Regards,

Jagan.

Re: Comparing two qvd file

Thu, 12 Apr 2012 11:16:55 GMT

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.

Comparing two qvd file

Fri, 13 Apr 2012 02:09:16 GMT

Hi Jagan and Hansiola,

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

Regards,