Conversion error with "\N" when using tonumber() in Multi-Field Formula tool.

Question

I have three text fields (that contain numbers) that I want to convert to a number (double) using the Multi-Field Formula tool and tonumber(). I keep getting the following error for the tool:

"ConvError: Multi-Field Formula (20): TONUMBER: \N lost information in conversion"

I am use to other errors that this tool produces but have not seen this one. From my knowledge, the "\N" means newline but I am not sure. I have tried trimming and using the Data Cleansing tool  on the fields but the error persists.

The file is a CSV and I am using Alteryx version 10.6

nicoleserrafero · Accepted Answer

Did some further investigating while trying to prepare a sample for my question (its a very large dataset) and found that there is literally "\N" in the field. So looks like I now know what the error is referring to.

Table looked like this before I converted the fields:

ABC1001 \N20023456234

Technically @CharlieS solved it I guess? Thanks for the help!