Skip to main content
Question

Duplicate Features Division


aashnaparikh
Participant
Forum|alt.badge.img+1

Hi, 

Based on the sample table, I want to implement a logic. 

  1. Same name, different policy # and same address - Goes to file 2
  2. Same name, different address and different policy number - The first record goes to file 1 and rest of the records go to file 2. 
  3. All the manual should again go to the file 2.
Policy Number New/ Renewal/ Manual Name Address To process Split 
123 New John Chris 123 Oxford St Y File 1
110 New Mary Jane 45 Caron ave Y File 1
111 New Mary Jane 360 Caron ave N File 2
112 Renewal Kent Bryan 333 Queen St Y File 1
113 Renewal Kayla Jan 333 Queen St Y File 1
114 Renewal Jung Chen 5 Queen St Y File 1
115 Renewal Jung Chen 5 King St N File 2
116 Manual Ray Ban 5 abc st N File 2
116 Manual Kan Can 6 xyz st N File 2
116 Manual Harry Potter 8 niagara st N File 2
116 Manual Rob Smith 9 India St N File 2
116 Manual Tony Stark 10 peter st N File 2
116 Manual John Snow 11 sandwich st N File 2
2000 New Melanie Joy 275 Rankin Avenue N File 2
2001 New Melanie Joy  275 Rankin Avenue N File 2

4 replies

evieatsafe
Safer
Forum|alt.badge.img+20
  • Safer
  • April 4, 2025

Hi ​@aashnaparikh sounds like you need a few DuplicateFilters and Testers. One to Tester for “Manual”, and DuplicateFilters for finding the first duplicate to send to file 1. I don’t quite understand the first point, but perhaps another DuplicateFilter with different matching attributes? 


aashnaparikh
Participant
Forum|alt.badge.img+1
  • Author
  • Participant
  • April 4, 2025

Hi Evie ​@evieatsafe , thanks for the response. 

 

What I meant in the first point that if we find features with the different policy numbers, however the person’s name and address is same it is likely caused due to human error and those features we want them in file 2 so that it gets manually reviewed


evieatsafe
Safer
Forum|alt.badge.img+20
  • Safer
  • April 4, 2025

Hi ​@aashnaparikh I don’t normally do this but I found this an interesting logic problem 🤔 I have recreated your scenario with the table provided and attached a template workspace with my solution. I ended up using the Matcher transformer because you want to know what is both the same and what is also different. 

I hope this either answers your question or at least gets you a headstart on your workspace! 


aashnaparikh
Participant
Forum|alt.badge.img+1
  • Author
  • Participant
  • April 8, 2025

Thank you ​@evieatsafe. It was a very good baseline for what I was trying to achieve. Appreciate the response


Reply


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