Hello,
My apologies if this is a relatively simple question. I'm a new Alteryx user and have been struggling with this particular problem and appreciate any help!
I'm looking for a way to compare the text in one column to see if it appears anywhere in another column, and output another column based on that check.
For example, say I have input data with text in two columns. I want to check if the values in column A appear anywhere in column B, and return true if they do.
Column A | Column B |
Apple | Orange |
Apple | Truck |
Pear | Apple |
Orange | Car |
Orange | Bridge |
Magical formula happens
Output data. The output column for Pear displays False since it does not appear anywhere in Column B. The output column for apple will always display true since it appears once in column B.
Column A | Column B | Output Colum |
Apple | Orange | True |
Apple | Truck | True |
Pear | Apple | False |
Orange | Car | True |
Orange | Bridge | True |
Thanks for the help!
Solved! Go to Solution.
That worked, thanks!