How to find duplicate record in to tables.
with check where issuence date comes 7 times means ticket issue six times.
Its urgent please any one.
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
load * from FirstTable
load Pno,Acode,Tno,Issueancedate from SecondTable;
load Distinct Pno,Acode,Tno,Issueancedate
You want to eliminate the duplicate records?
Add qvw if possible
Retrieving data ...