Sheets with different schema imported at once

Question

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!

Example.xlsx

caltang · Answer

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.

gorunsava · Answer

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?

JosephSerpis · Answer

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.