How to find duplicate records

[#1]

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

[#2]

Hello,

Its urgent please any one.

Thanks

[sreenivas]

You want to eliminate the duplicate records?

Add qvw if possible

[#4]

hi,

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

[SunilChauhan]

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]

yourTable:

load * from FirstTable

concatenate

load Pno,Acode,Tno,Issueancedate from SecondTable;

load Distinct Pno,Acode,Tno,Issueancedate

          From yourTable;