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
Solved! Go to Solution.
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