Solved

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

  • 15 May 2023
  • 2 replies
  • 75 views

Userlevel 1
Badge +1

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?

icon

Best answer by Cansu 19 June 2023, 10:37

View original

2 replies

Userlevel 4
Badge +3

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!

Userlevel 6
Badge +7

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? 

Reply