Dedupe Concept

[Rohan139]

Hi Peeps,

Given below is the Sample input data which is being generated after applying fuzzy logic on Name column.

ID1	ID2	NAME
P1	P2	Ravi
P1	P3	Ravi
P3	P4	Ravi
P3	P5	Ravi
P5	P6	Ravi
P7	P6	Ravi
P8	P6	Ravi
P9	P10	Sam
P9	P11	Sam
P9	P12	Sam
P14	P13	Sam
P15	P13	Sam
P16	P13	Sam

Further , I want to Assign a Single/Unique ID To all the ID's where Name is Same . 

Here's the desired Output.

ParentID	ChildID	Name
P1	P2	Ravi
P1	P3	Ravi
P1	P4	Ravi
P1	P5	Ravi
P1	P6	Ravi
P1	P7	Ravi
P1	P8	Ravi
P9	P10	Sam
P9	P11	Sam
P9	P12	Sam
P9	P13	Sam
P9	P14	Sam
P9	P15	Sam
P9	P16	Sam

Could anyone Help me with this?

Thanks in Advance. 

[IraWatt]

Hey @Rohan139,

You can do something like this:

The Summery Tool grabs the first ID1 for each Name then join that information back on.

Any questions or issues please ask :)
HTH!
Ira

[Rohan139]

Hey @IraWatt ,

Really thankful for your reply,  but the problem here is I just added name column in corresponding to both ID Columns just to give refrence that on these particular ID's  Name was common.

But actual output produced by fuzzy logic are only the  ID COLUMNS (ID1 and ID2) and the match score which i didn't added here as it is of no use as per my understanding.

Considering only the ID columns , can we still do the same as required.

[binuacs]

@Rohan139 another way of doing this

[MarqueeCrew · Accepted solution]

@Rohan139 ,

Alteryx created a magic tool, Make Group, just for this function.  It's in the JOIN category and there are 1-tool examples.

It will create ID1-ID1 relationships (easy to filter where the IDs are equal) that show all of the linkages reduced to the lowest ID value.

Configure and run.

Cheers,

Mark

[Rohan139 · Accepted solution]

Hey @MarqueeCrew ,

Thanks a ton for helping me out with this solution. 

Actually I am new to Alteryx and there are many things yet to be explored.

Will looking for more Amazing Logics and discussions 

Thanks & Grateful

[Aguisande]

This is the way an ACE suggests a solution!

Awesome work Mark!

This should count 10X points!!