How to remove duplicate records from Qlikview

[sarfaraz_sheikh]

Dear All,

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

Sarfaraz

[PrashantSangle]

Hi,

use Distinct

Regards

[sarfaraz_sheikh]

Dear Max,

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

Sarfaraz

[jagan]

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.

[#5]

Hi ,

Use DISTINCT Key word in load script

for eg:

Table:

load DISTINCT

clumn,

clumn

from data_tabel.xl;

thanks,

Raja

[#6]

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]

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

[#8]

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

[nikhilgarg]

Hey,

I have already shared my file in last reply.

[#10]

Hi,

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

thanks,

Krish