Input tool - multiple tabs

[ulrich_schumann]

Hi all,

out of an export from a reporting tool I received an Excel file with 58 (!) tabs. All tabs have different columns and content. Any chance to avoid 58 input tools and rather import all tabs in one go?

[tcroberts · Accepted solution]

Here's a great in-depth answer to your question: https://community.alteryx.com/t5/Engine-Works-Blog/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-Al...

The gist of it is that there's not a quick and easy way to do this. The Dynamic Input tool would work if the schema was the same from sheet to sheet, but this is not the case for you.

The author of the above post has uploaded a macro to the Alteryx Gallery which you can download and use to solve your problem. You can find it here:

https://gallery.alteryx.com/#!app/Read_All_Excel_Files/58dd51b3a18e9e18fca64172

You could probably rewrite something similar and avoid his first macro (File Finder), since you seem to only have 1 file.

All credit for the solution should go to @CameronS, who's saved me (and probably countless other Alteryx users) a ton of time with this.

[ulrich_schumann]

Great - I will have a look, seems very promising!

Thanks for your quick answer.