Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Formula Tool Incorrectly identifying text

HW1
Cometa

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 RESPUESTAS 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
Cometa

Right! Silly me 🙂 Thanks

Etiquetas
Autores con mayor cantidad de soluciones