This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thanks for posting in the community. After looking further into your request, we determined that there isn't a tool in Alteryx that allows you to query Excel files like if it was a database.
Now that doesn’t mean there isn’t another way. If you can assist me with the following questions, I may be able to help you further.
1st - Does this file contain multiple sheets?
2nd - Does it use formulas to calculate data or is it just values?
3rd - Is this 80mb file going to be used only once or multiple times?
If it's going to be used more than once, I'd recommend converting the file to a .csv format or an Alteryx database format .yxdb to improve the importing of the dataset.
Based on how you answer the three questions above we may be able to at least reduce the amount of time it takes Alteryx to read the whole file. Also, if you could provide a sample dataset and workflow it could help fast track a potential solution.
Best, John Posada Senior Customer Support Engineer - Alteryx