community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Help with matching values

Alteryx Partner

Hello!

 

I have a situation where I need to match values that are reversed. For example, I have one row which says apple/banana and another row which says banana/apple. For my purposes, apple/banana and banana/apple are the same thing and it doesn't matter which order the output is in. Can anyone help?

 

current output:

 

#Type
1Apple/Banana
2Banana/Apple

 

desired output:

 

#Type
1Apple/Banana
2Apple/Banana

 

Thanks in advance!

Alteryx Partner

Is it only ever 2 values ?

Highlighted
Alteryx Partner

See attached, a few more steps than is required for 2 values and 2 cells, but I'm guessing your real data is a bit more complex than this.

 

Basically I split, then sort the values, then connect them back together again.

Alteryx
Alteryx

I think @cmcclellan is likely the better approach. I utilized the "CompareDictionary" function to reorder the strings in the list. 

Quasar

Sample workflow

 

Help with matching values.PNG

Labels