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.
SOLVED

IF CONTAINS Malformed IF statement

TOzirsky
7 - Meteor

Hi,
Will someone please let me know how to fix this malformed IF statement?

IF CONTAINS([Live Products],"Comp")

OR IF CONTAINS([Live Products],"Onboard")

OR IF CONTAINS([Live Products],"Payment")

OR IF CONTAINS([Live Products],"Perf")

OR IF CONTAINS([Live Products],"Perf")

OR IF CONTAINS([Live Products],"Sala")

OR IF CONTAINS([Live Products],"Succ")

OR IF CONTAINS([Live Products],"Time")

OR IF CONTAINS([Live Products],"Touch")

OR IF CONTAINS([Live Products],"UKG Pro")

OR IF CONTAINS([Live Products],"Ulti") THEN "Y" ELSE Null() ENDIF

 

The Data type is V_WString


Thanks,
Tim

 

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

Just the answer?

 

F CONTAINS([Live Products],"Comp")

OR CONTAINS([Live Products],"Onboard")

OR CONTAINS([Live Products],"Payment")

OR CONTAINS([Live Products],"Perf")

OR CONTAINS([Live Products],"Sala")

OR CONTAINS([Live Products],"Succ")

OR CONTAINS([Live Products],"Time")

OR CONTAINS([Live Products],"Touch")

OR CONTAINS([Live Products],"UKG Pro")

OR CONTAINS([Live Products],"Ulti") THEN "Y" ELSE Null() ENDIF

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels
Top Solution Authors