Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Its urgent please any one.
Thanks
You want to eliminate the duplicate records?
Add qvw if possible
hi,
we can find duplicate by using previos function with order by clause.
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
yourTable:
load * from FirstTable
concatenate
load Pno,Acode,Tno,Issueancedate from SecondTable;
load Distinct Pno,Acode,Tno,Issueancedate
From yourTable;