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?
Solved! Go to Solution.
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
Hi @Santhoshraj
Split to rows, filter: , Summarize, Group By Supplier
!Contains([Prev_Packagers],[New_Packagers])
@HomesickSurfer - Much cleaner than mine :D
Thanks a lot for the help both. @Carolyn @HomesickSurfer .