Input batch macro works in Designer in seconds but causes truncation error on the Server

Question

An 'analytic app' that imports all of the sheets in a file by reading the list of sheet names and then running a batch macro to import each one works perfectly in Designer and produces an output of all of the sheets of the input file on one sheet.

The 'analytic app' running on the Alteryx Server with the same input file runs for a very long time before outputting the error:

Number of records exceeds the Excel maximum (1048576). Remaining records will be truncated. (ToolId: 10)

There are 348 rows across all the different sheets, either the Alteryx Engine on the Server is reading all the blank rows or the app itself is getting stuck in some kind of loop but I can't see why it should be behaving differently.

Regards,

Ben

ben_hopkins · Answer

Thanks. Testing an output is a good idea. I'll get back to you.

fmvizcaino · Answer

Hey @ben_hopkins ,

I think you are correct, sometimes Alteryx reads the blank rows from excel and can cause that problem. I suggest you including another macro output with the count of rows for each file, that will help you checking which file you need to check and delete the blank rows.

Another suggestion is to include a filter tool inside macro eliminating the null rows.

Best,

Fernando Vizcaino