Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Record size of the CSV is too large to read from zip

novalcia
7 - Meteor

I can usually input a zip file into alteryx and it will read the files in the zip. Today I get this error:
"Record size of the CSV is too large to read from zip. Reduce to less than 256kb or select ‘First Row Contains Field Names’"

I don't know what happened, this has never happened before. I can't select "First row contains field names" because it doesn't.

The csv size inside of the zips I usually input are 96GB and it works fine. This one contains 36GB of csv and I got this error.

 

2 REPLIES 2
apathetichell
20 - Arcturus

The delimiter is probably wrong. This is saying that a single row/column is 256kb. you probably normally use ,s and this file uses tabs or something. regenerate it and confirm the delimiter is the expected delimiter ---> or if you are daring try open it in something like notepad (or stream in a few rows using csv stream tools in python) ---> make sure to use no delimiter mode there to see the structure.

dreldrel
9 - Comet

The error does not relate to the overall CSV size, but to the size of a single record within the CSV file inside the zip, which currently exceeds Alteryx's 256 KB limit when reading zipped files.

Labels
Top Solution Authors