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

Help with matching values

jvirtanen0201
6 - Meteoroid

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!

4 REPLIES 4
cmcclellan
13 - Pulsar

Is it only ever 2 values ?

cmcclellan
13 - Pulsar

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.

BenBo
Alteryx Alumni (Retired)

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

ponraj
13 - Pulsar

Sample workflow

 

Help with matching values.PNG

Labels