Alteryx input tool cannot read the last row of the Excel sheet

Question

Hi all, when I try to input a very large excel file, with 1,048,576 rows in an excel tab, and perform a join with another table with similar amount of data (essentially I was trying to perform a vlookup and see if ID in one excel is present another excel), I notice the 1048576th record did not get read by the input tool. Anyone knows how to work around it?

EloraV · Answer

Hello everyone,

Same problem here.

The settings mentioned by Qiu are correct : the record limit is empty (I even tried to set it 1048576), and the import start on line 1.

My first contains field names so I should have 1048575 lines of real data but I only have 1048574. The last one disappeared.

danilang · Answer

Hi @peterNinja

If you don't have the "First Row Contains Data" checked in the Input options, the first row of data will be converted to column headers, so the total reported rows in Alteryx will be one less than the last row number in the Excel file

I think it's also the first time that I've actually seen a file with the absolute maximum of rows. Any time I've had to deal with sheet roll-over, I've always capped it an even 1M rows.

Dan

Qiu · Answer

@peterNinja 
Not having the same experience before. Guess you can not share the file?

Just in case, can you check the highlighted part?