Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Match or Find values in one column based on another column

Highlighted
Meteor

Hello all

 

I am trying to find/match/flag records that match values in one column based on another column. I tried few ways as in attached picture but I couldnot make it work. Field 2 will always have multiple (number of entry varies in that field) records with comma.

 

Can anyone help ?

 

CaptureColumns.PNG

 

 

 

Thank you

Highlighted
Alteryx
Alteryx

Hi @slckkrky 

 

The top one should work, but you need the fields the other way round.

 

It should be Contains( [the long field you're searching in] , [what you're searching for] )

 

Let me know if that works.

 

Luke

Labels