Alteryx Designer Discussions

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

Fuzzy Match with Comma Separated Values in Same Column

muddobber26
7 - Meteor

Hello - I have a list where there is one column with a combination of part numbers (ex: 102467-00) that are separated by commas. Some cells in the column could have as many as 40 different part numbers. Some of the cells will contain a list of part numbers that are 100% the same except they are in different orders. I am trying to use the fuzzy match tool to create a list of unique part number combinations where order does not matter. For example, the table below is all of the same part numbers but in different orders. How do I output just one of these cells? Any guidance? 

 

101220-89,104306-14,123678-87,134789-93

134789-93,101220-89,104306-14,123678-87

04306-14,134789-93,101220-89,123678-87

 

 

3 REPLIES 3
mceleavey
17 - Castor
17 - Castor

Hi @muddobber26 ,

 

Is there any reason you need to use the Fuzzy Matching tool?

 

The simple way of doing this is to first assign a record ID to each row, then use the Text to Columns tool to parse these records into rows using the comma:

mceleavey_0-1651766162591.png

This gives the following data:

mceleavey_1-1651766191621.png

 

You can then sort the records by Record ID and cell value, so it will put them all into the same order:

mceleavey_2-1651766217766.png

 

You then simply concatenate in the Sum tool, unique the records on the cell value and join back to the original stream. This will then only bring through the unique values of cells regardless of the order of each element within the cell:

mceleavey_3-1651766253375.png

This returns two rows:

mceleavey_4-1651766283469.png

Deeming the second row to be a duplicate of the first:

 

mceleavey_5-1651766308462.png

Workflow attached.

 

I hope this helps,

 

M.

 

 



Bulien

muddobber26
7 - Meteor

Thank you this works!

mceleavey
17 - Castor
17 - Castor

no problem.gif



Bulien

Labels