Sheets with different schema imported at once

[gorunsava]

Hello everybody!

I have an Excel file wich have several sheets with different schema; some columns are same, some of them are different. I have 28 sheets in the file, but I cannot send here that one, so I will send you a simplified file with three sheets which correspond to the description above.

Is it possible to import all of them in Alteryx at once? I am sure the solution for the file I am sending here will be applicable for my file.

Thank you in advance!

[binuacs]

@gorunsava @Try the batch macro

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flo...

[JosephSerpis]

Hi @gorunsava you can achieve what you are asking for have a look at this article which will show you how you can do this.

[gorunsava]

Is this applicable for my example? I couldn't do what I want with these solutions... I think that example you gave me is example for several files with different schema, but I have problem to import several sheets with different schema from one Excel file at once. Is it possible to do so?

[caltang]

Yes! Use a Directory tool rather than the normal Input Data tool. Then use the Formula tool to change the file path to include the relevant sheet names that’d you’d like. 

Or you can use the Input tool to call in the .xlsx files and then have them refer to <List of Sheet Names>, then the batch macro can work from there too.