Fuzzy Match with Comma Separated Values in Same Column

[muddobber26]

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

[mceleavey · Accepted solution]

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:

This gives the following data:

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

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:

This returns two rows:

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

Workflow attached.

I hope this helps,

M.

[muddobber26]

Thank you this works!

[mceleavey]