I would like to filter duplicate combinations in an different order. In the example the "C and A" and "B and A" combination should be filtered out. Does anyone have an idea?
Thank you in advance
Solved! Go to Solution.
I added one row in order to test.
1- I added a formula to concat both column
2- I added a join between two keys column if it match I will not take them if not I'll get them (Last row in our case)
Attached the workflow,
Hope this helps!
Regards
Thank you for your time @atcodedog05 and @messi007 ,
Maybe I expressed myself misleadingly.
I would like to have this Input:
And get this Output:
I just want to remove these rows, which I already have in a different order.
Thank you :)
@atcodedog05 Exactly what I want. Thank you very much 😊
Happy to help : ) @Robinvm
Cheers and have a nice day!