Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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