Skip to main content
Solved

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

S
Data Pioneer
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 Cansu

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? 

View original

M
Star Blazer L2
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!

Cansu
1 person likes this
  • Cansu
    Cansu
Cansu
Community Manager
Forum|alt.badge.img+3
  • CansuCommunity Manager
  • Community Manager
  • June 19, 2023

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? 

Check out our Quick Start Guide to get started on the community 🙋‍♀️

Reply


Community Terms of Use & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings