topic Re: How to remove duplicate records from Qlikview in QlikView

How to remove duplicate records from Qlikview

sarfaraz_sheikh — Wed, 11 Mar 2015 07:43:00 GMT

Dear All,

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

Sarfaraz

Re: How to remove duplicate records from Qlikview

PrashantSangle — Wed, 11 Mar 2015 07:47:43 GMT

Hi,

use Distinct

Regards

Re: How to remove duplicate records from Qlikview

sarfaraz_sheikh — Wed, 11 Mar 2015 07:49:42 GMT

Dear Max,

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

Sarfaraz

Re: How to remove duplicate records from Qlikview

jagan — Wed, 11 Mar 2015 07:54:37 GMT

Hi,

Try like this

Data:

LOAD DISTINCT

FROM DataSource;

Data:

LOAD DISTINCT

Column1,

Column2,

FROM DataSource;

STORE Data INTO FileName.qvd;

Hope this helps you.

Regards,

Jagan.

Re: How to remove duplicate records from Qlikview

Wed, 11 Mar 2015 08:04:25 GMT

Hi ,

Use DISTINCT Key word in load script

for eg:

Table:

load DISTINCT

clumn,

clumn

from data_tabel.xl;

thanks,

Raja

Re: How to remove duplicate records from Qlikview

Wed, 11 Mar 2015 08:13:06 GMT

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

Re: How to remove duplicate records from Qlikview

nikhilgarg — Wed, 11 Mar 2015 09:34:50 GMT

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

Re: How to remove duplicate records from Qlikview

Wed, 11 Mar 2015 09:38:15 GMT

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

Re: How to remove duplicate records from Qlikview

nikhilgarg — Wed, 11 Mar 2015 10:48:19 GMT

Hey,

I have already shared my file in last reply.

Re: How to remove duplicate records from Qlikview

Wed, 11 Mar 2015 11:46:41 GMT

Hi,

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

thanks,

Krish

Re: How to remove duplicate records from Qlikview

nikhilgarg — Wed, 11 Mar 2015 11:50:02 GMT

Hey,

but dupliacte records wil be deleted by adding Where not exists()