Removal of duplicates when there is a partial match

Question

Hello-

We are working with a list of numbers separated by commas. We are looking to have the lines that contain "part" of what another line contains, removed.

For example:

Before          After

4,5,9          3,4,5,9

3,4,5,9

5,9

3,5,9

I was unable to find solutions to this so any help would be appreciated.

Thank you,

mjawahir · Answer

How to combine when data is partially matching.?

Please refer the attached excel for data input:

when item no, text, text1 are same and if the data column having partial matching need to club the price A, price B so 3 lines will come as 1 row with the added price. since item no 9 is having different should leave as it is.

Please guide me or suggest a tool to do this task.

Alteryx Clarification.xlsx

Watermark · Answer

Are you needing it in 3 rows?  Not clear on what you're trying to achieve in the 'after' . What is the result goal? You need to know all the individual numbers that are in the 'before'?   It should work the exact same regardless of row count or what's in the row

stevecassidy7777 · Answer

Thanks for the quick response. It seems I may have over-simplified my data example. It would look more like the below example.

Before          After

4,5,9            3,4,5,9

3,4,5,9         1,2,6

5,9               40,41,42,43

3,5,9

1,2

1,2,6

1,6

40,41,42

40,41,42,43