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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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 ?

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