Drop Down Tools Won't Update for Large Files

Question

I've got an analytic app in my company's Gallery. I have it set up to allow users to select a CSV or Excel file and then feed the column names into drop down lists to allow users to map column names to expected inputs.

This works fine in most cases. However, I today uploaded an Excel file with ~1MM rows. After completing upload, it asked whether I wanted the list of sheets, or Sheet1. I selected Sheet1, but none of the dropdowns populated with the field list.

If I select 
, they all populate (of course, just with "Sheet Name").

This isn't an issue for smaller Excel or CSV files. Is there a limit on how many rows the Gallery can work with? And why would it have to look beyond the first row of the Excel spreadsheet anyway?

Loic · Answer

yes you need at least to install this at a minimum:

Microsoft Access Database Engine 2010 Redistributable

This download will install a set of components that can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications.

https://www.microsoft.com/en-us/download/details.aspx?id=13255

if you go there: https://help.alteryx.com/current/designer/data-sources and scroll to the Microsoft section, you will see a link to this "Microsoft driver" above a few times. This way you can show that it is officially recommended by Alteryx.

barnese · Answer

Hi @Loic I am helping out @lheureuxg to troubleshoot this and wanted to inquire about the Microsoft Drivers you mentioned in your post.  Currently our Company server does not have any Microsoft Office apps installed.  Is there a dependency on having Excel installed for the Alteryx tools to work properly?

lheureuxg · Answer

Thanks Loic,

It does work with that same Excel file when the same app is run in my own designer. I haven't attempted this on the Server-based designer... thanks for the suggestion, and I'll work through that with our team.