Hi I would like to know how we could use set analysis to identify duplicates in a data. Say for eg you want to identify duplicate sales transactions in a data.
Hi Nataraj, you can create a simple table with the dimensions you want to detect as duplicates, and an expression with a simple count on a field that you know always have data.
Those above 1 are duplicates (there is more than one record in that combination of dimension values), or to keep only duplicates:
May be explain little more, Not exactly set analysis but we will try our best to showcase
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
