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

Contains not working

doublej
7 - Meteor

I am attempting to use Contains to find text.  I have attached an example.  I would expect both records to return true.  Why would they not, isn't contains looking for an instance of the string not an exact match?

3 REPLIES 3
OllieClarke
15 - Aurora
15 - Aurora

You have your string and field the wrong way round. CONTAINS([Field1],'Jason') is what you're after

Thableaus
17 - Castor
17 - Castor

Hi @doublej 

 

The first thing to be evaluated is your Field. The string "target" should be "Jason".

 

The original function is Contains(String, Target)

 

Cheers,

doublej
7 - Meteor

that was it.  I was thinking that when I saw the structure as Contains(String,Target) it was the string I was looking for in the field (target).  thanks!

Labels