Skip to main content
Solved

How to detect duplicate records from a particular attribute in One Web?

  • May 15, 2023
  • 2 replies
  • 130 views

Forum|alt.badge.img+2

Hello all, is there anyone who knows about creating a rule to detect the duplicate records of a particular attribute and mark it as duplicate using one web?

Best answer by Ataccama Community Admin

Hi @suryakanth.Emisha I see that you’ve created a similar post here, are there any outstanding questions, or issues on this topic? Could you please share them 🙂

@Marnix Wisselaar may I ask if you’ve had a chance to see that post? 

2 replies

Forum|alt.badge.img+2

We have the same question. You could maybe use a validation component (?). In Desktop we use the Relationship Analysis step to check key-violations and orphaned records (FK) and export to a table in a DB. You could then read this table as a CI of course.

Maybe you could use it as a validation component? But we haven't figured out how to use this in a monitoring projects.

We tried aggrigation rules, but those didn't work for our larger datasets / CI.

Keep us posted!


Forum|alt.badge.img+1

Hi @suryakanth.Emisha I see that you’ve created a similar post here, are there any outstanding questions, or issues on this topic? Could you please share them 🙂

@Marnix Wisselaar may I ask if you’ve had a chance to see that post?Â