Type mismatch. Number provided where a string is expected

[lmilimonka]

Hi,

I have a customer name that starts with 9 and the rest of the customers is all text. I get this error:

Parse Error at char(1): Type mismatch. Number provided where a string is expected

Because this is the first customer in the column, Alteryx has it definited that column as double.

What kind of function can I use to ensure that this parses correctly.

Thanks 

[binuacs · Accepted solution]

@lmilimonka use toString([Field]) function