2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dedupe Concept

Rohan139
6 - Meteoroid

Hi Peeps,

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

ID1ID2NAME
P1P2Ravi
P1P3Ravi
P3P4Ravi
P3P5Ravi
P5P6Ravi
P7P6Ravi
P8P6Ravi
P9P10Sam
P9P11Sam
P9P12Sam
P14P13Sam
P15P13Sam
P16P13Sam

 

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

 

Here's the desired Output.

 

ParentIDChildIDName
P1P2Ravi
P1P3Ravi
P1P4Ravi
P1P5Ravi
P1P6Ravi
P1P7Ravi
P1P8Ravi
P9P10Sam
P9P11Sam
P9P12Sam
P9P13Sam
P9P14Sam
P9P15Sam
P9P16Sam

 

Could anyone Help me with this?

Thanks in Advance. 

6 REPLIES 6
IraWatt
15 - Aurora

Hey @Rohan139,

You can do something like this:

IraWatt_0-1654000196250.png

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
6 - Meteoroid

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
15 - Aurora

@Rohan139 another way of doing this

 

binuacs_0-1654001566782.png

 

MarqueeCrew
19 - Altair
19 - Altair

@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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Rohan139
6 - Meteoroid

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
14 - Magnetar
14 - Magnetar

This is the way an ACE suggests a solution!

Awesome work Mark!

This should count 10X points!!

Labels