Compare values in two columns with commas

[Santhoshraj]

Hi , I have a sample table like this :

Supplier	Base	Prev_Packagers	New_Packagers
AAAA	1234	A1,B1,C1	A1,B1
BBBB	1345	V1	Z1
CCCC	5431	A2,B2	B3,G3
DDDD	3451	F4	F4

For each Supplier-Base, i want to filter only the rows where there is no match between prev and new packagers.

Output must be something like this: 

Supplier	Base	Prev_Packagers	New_Packagers
BBBB	1345	V1	Z1
CCCC	5431	A2,B2	B3,G3

How to get this done?

[Carolyn]

I'm really curious to see what others suggest... What I would do:

1) Split both Prev and New Packagers to row, using the comma delimiter

2) Add a filter for where Prev != New

3) Using the False output, which means they are the same, Join with the original data

4) The J output anchor will show lines where there are dupes (if you want to use that output, just add a Unique Tool on there)

5) Use the right output which would mean there were not any dupes

 

 

[HomesickSurfer · Accepted solution]

Hi @Santhoshraj 

Split to rows, filter: , Summarize, Group By Supplier

!Contains([Prev_Packagers],[New_Packagers])

[Carolyn]

@HomesickSurfer - Much cleaner than mine :D 

[Santhoshraj]

Thanks a lot for the help both. @Carolyn @HomesickSurfer .