Excel file size (500 mb) Loading in alteryx

[Anasalter]

Hi,

I have a excel having 1 million rows and 124 columns (500 mb) file when i am trying to input this file in alteryx it is not even loading and taking so much of time.
Any solutions will help.

[ChrisTX]

Try File Format Microsoft Excel Legacy (*.xlsx) and the AMP engine option.

[Anasalter]

@ChrisTX i have tried  but it is showing the error 'String size limit reached:'

[ChrisTX]

can you post a screenshot of the workflow and error, and a sample of your input Excel file?

[Anasalter]

@ChrisTX i have attached the Screenshot FYR.

[ChrisTX · Accepted solution]

Without a copy of the XLSX file, I can only guess that there may be a cell (maybe a merged cell) that contains many characters.

Try the trial-and-error approach:

In the Input Data tool, use the Record Limit.  Read in 10 or 100 records, and see if the workflow completes without errors. 

Then read in 50k or 100k records. 

Then increase the Record Limit until you find where the error is in the Excel file.

Chris