topic Re: Duplicate rows in qvd in QlikView

Duplicate rows in qvd

Wed, 27 Aug 2014 10:42:08 GMT

Hi,

Does the qvd allow to store duplicate rows?

Thanks

Puni

Re: Duplicate rows in qvd

MK_QSL — Wed, 27 Aug 2014 10:54:32 GMT

Yes.. .Try below...

Sales:

Load * Inline

[

Customer, Sales

A, 100

B, 120

C, 140

];

Store Sales into Sales.qvd(QVD);

Re: Duplicate rows in qvd

Wed, 27 Aug 2014 10:58:26 GMT

Thanks Manish.

I just got to know QVD allows to store duplicate rows, but when we concatenate the qvd data with inline data (contains same data as qvd) removes duplicate

Gone through the following thread

Concatenation - De - duplication of Rows

Thanks

Puni

Re: Duplicate rows in qvd

MK_QSL — Wed, 27 Aug 2014 11:02:20 GMT

Kindly clarify little more on you requirements... Thanks

Re: Re: Duplicate rows in qvd

ashfaq_haseeb — Wed, 27 Aug 2014 11:08:01 GMT

Hi,

have a look at attached application.

Its works and stores duplicate data too.

Regards

ASHFAQ

Re: Duplicate rows in qvd

Wed, 27 Aug 2014 11:09:54 GMT

Hi,

In my IL script testing , I concatenate the data from qvd and data pulled from sql db. I noticed that record count is not in sync between full load and incremental load. I wondered does the qvd stores duplicate record or not.

Now i got clarified that in full load qvd contains all rows though it is duplicate. But in incremental load duplicates are eliminated as i have used CONCATENATE, so qvd contains less rows than full load qvd.

Thanks

Puni