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.

Searching for name using contains

Highlighted
Meteoroid

 Hi All,

 

Happy Friday!.. i am trying to do the following....

 

[Mgr Level 2] contains "Arun" or [Mgr Level 3] contains "Arun" or [Mgr Level 4] contains "Arun" or [Mgr Level 5] contains "Arun"

 

 

It gives me a parse error...can you please help...

 

Highlighted
Magnetar
Magnetar

Try the following formula:

 

Contains([Mgr Level 2],"Arun") OR Contains([Mgr Level 3],"Arun") OR Contains([Mgr Level 4],"Arun") OR Contains([Mgr Level 5],"Arun")

 

Does that work for you?

 

NJ

Highlighted
Asteroid

Hi, 

 

Is it possible to use a list of keywords in this scenario?

 

Fiorano

Labels