I am getting a parse error at char: unmatched

Question

if contains([product_group],"XX") AND contains([marketing], "YY") then "XXYY" elseif contains ([product_group],"AA") AND contains([marketing], "BB") then "AABB" elseif contains ([product_group],"CC") AND contains([marketing], "DD") then "CCDD" elseif contains  ([marketing], "Proj A") then "Project A" elseif contains([marketing], "Proj B") then "Project B" elseif contains([marketing], "Suppt") then "Support team" elseif contains([marketing], "ABC") AND contains([marketing], "mgmt") and contains([marketing], "ABCDE") then "CONSULTING"

elseif ([product_group])

endif

JagdeeshN · Answer

Hi @Lauramaria ,

You are missing the 'else' clause which results in this error.

Please find below a modified statement with the else.

if contains([product_group],"XX") AND contains([marketing], "YY") then "XXYY" elseif contains ([product_group],"AA") AND contains([marketing], "BB") then "AABB" elseif contains ([product_group],"CC") AND contains([marketing], "DD") then "CCDD" elseif contains ([marketing], "Proj A") then "Project A" elseif contains([marketing], "Proj B") then "Project B" elseif contains([marketing], "Suppt") then "Support team" elseif contains([marketing], "ABC") AND contains([marketing], "mgmt") and contains([marketing], "ABCDE") then "CONSULTING"

else ([product_group])

endif

Hope this helps.

Best,

Jagdeesh