Alteryx Designer Desktop Discussions

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

Using contains formula to look through entire column

Travis_Ratliff
8 - Asteroid

Hey all,

 

I have attached a sample of my workflow. 

 

I am using a contains formula to check if the name in column 2 is in column 1 but currently it only checks row by row. What I want is for it to look through the entirety of column 1. For example, in the sample workflow only row 3 would say "N/A" and all others would say "Match"

 

Any help is appreciated

Thanks

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @Travis_Ratliff 

 

One way of doing this

 

Felipe_Ribeir0_0-1668462949971.png

 

Labels
Top Solution Authors