In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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