Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Formula Tool Incorrectly identifying text

HW1
9 - Comet

I have a formula tool with the formula:

 

 

IF Contains("Services / Site", [Value]) 
THEN "Services" 
ELSE Null()
ENDIF

 

 

It does not identify the text correctly.

HW1_0-1618979568306.png

 

 

Please find the attached workflow for an example

 

Why is it happening?

2 REPLIES 2
Luke_C
17 - Castor
17 - Castor

Hi @HW1 

 

At first glance it looks like you have the contains function backwards. The syntax is contains([Field], string you want to find in the field)

 

 

HW1
9 - Comet

Right! Silly me 🙂 Thanks

Labels
Top Solution Authors