I'm getting in error on my input that says "Fields must be smaller than 16m."

[corinne_milligan]

I'm getting in error on my input that says "Fields must be smaller than 16m."  What precisely does this mean?  What's the m?  Is there a row limit?  Thanks.

[MattH · Accepted solution]

Ususally this error occurs when the file is failing to delimit properly, or mis-formatting some other way so that one value doesn't get closed and the entire rest of the file winds up in that field. If you are using the default setting of "ignore delimiters in quotes" in the properties of the Input tool, try setting that property to "none".

For the error itself, we do not support fields larger that 16 megabytes in size.  There are no limits on how many rows you can have.

[pawel_mieczkowski · Accepted solution]

I had the same issue. My work around is to go to input option, and under "Ignore Delimiters in" change the default value "Quotes" to "Single Quotes"

[SeanAdams]

Hey @corinne_milligan
 
Are you OK to mark @MattH 's or @pawel_mieczkowski's solution as 'Solved"?   That way, this can contribute to the body of knowledge that folks can search for worked solutions.
 
Community Team - if @corinne_milligan is not able to get to this in a week or two - would you mind marking this as solved?
 
Thank you
Sean

[NJT]

This is why I love the Alteryx community and the new search features are great too, 7 years later this post is still relevant and helped me! I always know if I encounter any issues a quick search here and I'm on my way again.

Thanks, for posting the question and thanks for marking it solved @corinne_milligan! And thanks for the solve @MattH 

[vasher]

I'm still getting this error. Tried setting the "Ignore Delimiters in" property to "None" as well as to "Auto" and "Single Quotes" - none of these worked for me. The file that I'm trying to import has a column with a large text stream (contains email chains).