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.
Solved! Go to Solution.
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
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
Hi @Tim6, would you be able to share an anonymized version of your data for us to look at? Attached is a sample implementation of the formula logic.
Thank you so much @AbhilashR, it works now - I changed the data type to V_WString.
Thank you for reaching out to the Community! Please mark this post as a solution accepted if you don't mind.