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

[nicoleserrafero]

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

[CharlieS]

Would it be possible to share a sample input file that produces this error? 

[nicoleserrafero · Accepted solution]

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:

A	B	C
100	1	\N
200	2	3
456	23	4

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