Parse Error at char(0): IN(...) Parameter #1 has a type mismatch.

Tim6

Hi There,

I am encountering some issues with this formula:

IF [Old Goal] IN("1","2","3") and [New Goal] >= 8 THEN "Yes" ELSE "No" ENDIF

I keep getting this error: Parse Error at char(0): IN(...) Parameter #1 has a type mismatch.

But i have checked the data type of the input using the select tool and it is double.

This is consistent with the datatype i used in the formula.

Please help.

Thank you.

Expression

Accepted answers

AbhilashR

Thank you for reaching out to the Community! Please mark this post as a solution accepted if you don't mind.

All comments

AbhilashR

Hi @Tim6, Alteryx doesn't like double quotes if the incoming column is a numeric value (int, double etc.). It needs double quotes only when the column is a string (or variant of string) datatype. The following formula would be applicable in your case -

IF [Old Goal] IN(1,2,3) and [New Goal] >= 8 THEN "Yes" ELSE "No" ENDIF

Tim6

Thank you very much @AbhilashR.

It works, but i don't think my new column was added because there is nothing in the data preview.

Please let me know what you think

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703