Excel File Reading Limit

Question

Hello,

I am seeing an issue with Alteryx reading an excel file.  I have narrowed it down after testing. The file is unable to be read by Alteryx after it exceeds  ~268 MB.  I have made this single dynamic input into its own flow, I have remapped it, dropped it manually in by itself

Is there a potential solution to this issue? I thought Alteryx wasn't limited on its file size.

Error Code is here: "String size limit reached: Strings are limited to 2147483648 bytes"

Please see the attached photo:

Largest file size that processes seems to be ~268MB / 269ish MB, the 269,919 KB file couldn't be read while the 268,280 KB can be read and the remainder of the workflow is completed. This is an all client report that I am only removing ~1.5k rows from a single client (to reduce bias) at a time and then saving, trimming again when I get an error and resaving until the file was read.

Screenshot 2025-02-24 143243.png

OTrieger · Answer

@SkyDe

You normally betting this error when the wrong delimiter is selected, as then Alteryx not manage to break the data into columns. Check which delimiter is needed.

apathetichell · Answer

Yup - as @OTrieger points out - that limit is a single vw_string value/cell - so you'd have to be loading the entire contents of the excel file into a single row/field to hit this. Your screenshot is useless. Perhaps a screenshot of your flow? some configurations? the error message?

OTrieger · Answer

@SkyDe 
This error is not relating to the file size but to the length of a string row.

Are these files are xlsx or csv?