Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
14 - Magnetar
14 - Magnetar

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