topic How to find duplicate records in QlikView

How to find duplicate records

Fri, 21 Dec 2012 08:18:33 GMT

Hi,

How to find duplicate record in to tables.

FirstTable:

Pno,Acode,Tno,Issueancedate

SecondTable:

Pno,Acode,Tno,Issueancedate,Custname,Email,Phoneno,Sector

with check where issuence date comes 7 times means ticket issue six times.

Thanks

Fri, 21 Dec 2012 08:31:54 GMT

Hello,

Its urgent please any one.

Thanks

sreenivas — Fri, 21 Dec 2012 08:54:55 GMT

You want to eliminate the duplicate records?

Add qvw if possible

Fri, 21 Dec 2012 08:55:01 GMT

hi,

we can find duplicate by using previos function with order by clause.

SunilChauhan — Fri, 21 Dec 2012 09:14:41 GMT

count( all fieldname)- count(distinct fieldName)

will show you no of duplicate recards

and if u add field in dimension then you will find what are the duplicate records

hope this helps

farolito20 — Wed, 02 Jan 2013 19:55:10 GMT

yourTable:

load * from FirstTable

concatenate

load Pno,Acode,Tno,Issueancedate from SecondTable;

load Distinct Pno,Acode,Tno,Issueancedate

From yourTable;