We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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