Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Duplicate rows in qvd

Hi,

Does the qvd allow to store duplicate rows?

Thanks

Puni

Tags (4)
5 Replies
MVP
MVP

Re: Duplicate rows in qvd

Yes.. .Try below...

Sales:

Load * Inline

[

  Customer, Sales

  A, 100

  A, 100

  A, 100

  B, 120

  B, 120

  C, 140

];

Store Sales into Sales.qvd(QVD);

Not applicable

Re: Duplicate rows in qvd

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

MVP
MVP

Re: Duplicate rows in qvd

Kindly clarify little more on you requirements... Thanks

Re: Re: Duplicate rows in qvd

Hi,

have a look at attached application.

Its works and stores duplicate data too.

Regards

ASHFAQ

Not applicable

Re: Duplicate rows in qvd

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

Community Browser