Excel output exceeds the limit of records

[victor_chowdhury]

I would love to have alteryx dump the excess amount of records on a new sheet in the same excel file that the user creates for dumping the output.

[PoornimaF]

Dear Victor,

Thanks for the suggestion. I take it you are referring to the New Excel driver for xlsx? The record limits on the sheet are imposed by Excel; when the number of rows that the user is trying to write via Alteryx exceeds this limit, then the Alteryx Excel driver aborts the process and warns the user, whereas the legacy Excel driver writes the allowed maximum without a warning. Adding the excess records to a new sheet would not help get around this issue for multiple reasons. 

First and foremost – the size of the entire file is also an issue – you cannot just write sheet after sheet of max data without overflowing the entire file. Therefore, we would actually need to overflow to additional files, and not sheets.  This would then lead to additional confusion for our users in terms naming the overflow files, as well as keeping track of the order in which the data was written.

As our CTO likes to say, Excel is not a database. If you are running into issues in terms of file size with Excel, please take a look at using yxdb or other formats that allow larger amounts of data support.

Best,
Poornima Farrar, Product Manager