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