Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter out the Rows with the same combination in an different order

Robinvm
8 - Asteroid

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? 

 

Robinvm_0-1645614231164.png

 

 

Thank you in advance

6 REPLIES 6
messi007
15 - Aurora
15 - Aurora

@Robinvm,

 

I added one row in order to test.

 

messi007_0-1645614700584.png

1- I added a formula to concat both column

 

messi007_1-1645614743260.png

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)

 

messi007_2-1645614820550.png

Attached the workflow,

Hope this helps!

Regards

atcodedog05
22 - Nova
22 - Nova

Hi @Robinvm 

 

Here is how you can do it.

 

Edit: similar to @messi007 I have just added a hyphen (-) in between so that matches are exact

 

atcodedog05_0-1645615309004.png

 


Workflow:

atcodedog05_0-1645615219082.png

 

Hope this helps : )

 

Robinvm
8 - Asteroid

Thank you for your time @atcodedog05 and @messi007 ,

 

Maybe I expressed myself misleadingly.

 

I would like to have this Input:

Robinvm_0-1645615532484.png

 

And get this Output:

 

Robinvm_1-1645615612252.png

 

I just want to remove these rows, which I already have in a different order.

 

Thank you :)

 

atcodedog05
22 - Nova
22 - Nova

Hi @Robinvm 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1645615849640.png

 

Hope this helps : )

 

Robinvm
8 - Asteroid

@atcodedog05 Exactly what I want. Thank you very much 😊

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Robinvm 

Cheers and have a nice day!

Labels