Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sarfaraz_sheikh
New Contributor III

How to remove duplicate records from Qlikview

Dear All,

How i can remove the duplicate records from QVD ....Is there any possible way to do so !!!!!!!!

Sarfaraz

10 Replies

Re: How to remove duplicate records from Qlikview


Hi,

use Distinct

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
sarfaraz_sheikh
New Contributor III

Re: How to remove duplicate records from Qlikview

Dear Max,

Can you put any example for my understanding ..........

Sarfaraz

MVP & Luminary
MVP & Luminary

Re: How to remove duplicate records from Qlikview

Hi,

Try like this

Data:

LOAD DISTINCT

*

FROM DataSource;

OR

Data:

LOAD DISTINCT

Column1,

Column2,

'

'

'

FROM DataSource;

STORE Data INTO FileName.qvd;

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: How to remove duplicate records from Qlikview

Hi ,

Use DISTINCT Key word in load script

for eg:

Table:

load DISTINCT

clumn,

clumn

from data_tabel.xl;

thanks,

Raja

Not applicable

Re: How to remove duplicate records from Qlikview

Hi Sarfaraz,

The Question is not Clear here, do you want to remove duplicates while loading or you want to remove Duplicate in existing QVD?

In 1st case as Jagan told above the is the solution and in

2nd case use incremental load concept

nikhilgarg
Valued Contributor

Re: How to remove duplicate records from Qlikview

HEy,

I tried implememting incremental load but it is not giving expected result. I ahve attached the application. In that , i am getting values in SalesData1 but while concatenating it is fetching data from qvd of first occurence and not of last updated date as in case of Region é'.

thanks

Not applicable

Re: How to remove duplicate records from Qlikview

pls share the file are else i will send a qvw with example EOD

nikhilgarg
Valued Contributor

Re: How to remove duplicate records from Qlikview

Hey,

I have already shared my file in last reply.

Not applicable

Re: How to remove duplicate records from Qlikview

Hi,

  In the script by using the "Where exists(FieldName);"  function possible to remove the duplicate records.

thanks,

Krish