Skip to main content
Question

Grouping duplicated values and assigining certain value for duplicates


Forum|alt.badge.img

Hey,

I am working on table which include duplicates for address field. Earlier I had to define one record from the duplicate set and assign there value "keep" and for the rest of duplicated records I had to assign value "dup". In the end of the day, duplicated records need to be found in the repository with attribute Merged_Id which indicate ID of the "keep" record from the duplicated set.

I would like to ask how to do it in the smartest way, considering conditions that if Merged_ID has missing value and address is duplicated in the certain group (left side of the pic), duplicated records 'dup' will have Merged_ID the same as "keep" record (right side of the pic).

Thank you!

8 replies

pratap
Contributor
Forum|alt.badge.img+11
  • Contributor
  • June 28, 2018

Hi,

Assuming that you want to fill only Merged_ID attribute and you will submit values in Merged_ID attribute as you have provided in sample excel

Kindly find the workbench attached

xlsxr2none.fmw

Pratap


redgeographics
Celebrity
Forum|alt.badge.img+49

Looks like @pratap and I were working on this at the same time. I like that solution (it does require the data to be sorted, but a Sorter will do that of course), but here's mine too anyway.


takashi
Influencer
  • June 28, 2018

There is more than one way. The advantage of this workflow is that it won't block feature flow. I would adopt this VariableSetter/Retriever approach if the performance is critical.


Forum|alt.badge.img
  • Author
  • June 28, 2018

Thank you for all answers and solutions, I will test them!


taojunabc
Participant
Forum|alt.badge.img+6
  • Participant
  • June 28, 2018

You can also use the following method.


pratap
Contributor
Forum|alt.badge.img+11
  • Contributor
  • June 28, 2018
taojunabc wrote:

You can also use the following method.

This is the same which I suggested

 

 


taojunabc
Participant
Forum|alt.badge.img+6
  • Participant
  • June 28, 2018
pratap wrote:
This is the same which I suggested

 

 

I am very sorry, I only saw the answers of redgeographics and takashi.

 

 


pratap
Contributor
Forum|alt.badge.img+11
  • Contributor
  • June 29, 2018
taojunabc wrote:
I am very sorry, I only saw the answers of redgeographics and takashi.

 

 

No issues,I understand.

 

You have to add one more condition (before this condition) that if value exists retain the value...

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