Hello @suryakanth.Emisha, I am not sure what is your version, but in the current version of Ataccama ONE you can define Aggregation rules which also include Uniqueness rules. In the documentation there is an example how to configure a uniqueness rule that will chek if the combination some attributes is unique or if there are any duplicates in the data: https://support.ataccama.com/home/docs/aip/13.9.0/user-guides/one-web-application-user-guide/data-quality/working-with-rules/aggregation-rules#AggregationRules-UniqueGroup 

Is it what you were looking for?

Kind regards,

Anna

Hello @anna.spakova , thanks for the help. I’ll try this method and let you know the resultant later tomorrow!

Hi @suryakanth.Emisha, could you let us know if everything worked as planned

If yes, we would appreciate it if you could take a moment to mark Anna’s answer “Best Answer” and vote on the topic survey. Thank you!

@anna.spakova , i have to check for duplicates based on one particular attribute, so the documentation which you referred works fine with two values, i have to check with one. Should i go with creating lookup or is there any other way you know?

@suryakanth.Emisha the principle is still the same, in your case simply use just one attribute to create the group and then follow the instructions.

I’ve worked on this method now and waiting to know the result of this from my seniors, thanks for the help @anna.spakova !