Importing multiple excel files with multiple sheets of different schema using batch macros

Question

Hi,

I have 20+ excel files having  5 sheets in each of them. They have different schemas too. the first sheet in every files are same, the second sheets in every files are same and as so on. I am trying to come up with a batch macro so i could pull all these files at once. i tried many ways but none of them gave the desired output. can anyone please share some knowledge on how to do this?

Thanks in advance

grossal · Answer

Hi @atcodedog05,

yes it does. As shown in the example, I load two files with 2 sheets at once 🙂

Best

Alex

atcodedog05 · Answer

Hi @grossal

Does it handle both multiple files and multiple sheets at the same time ?

grossal · Answer

Hi @Govind_Dileep_G,

the easiest way that I know is to use the CReW Macro "Wildcard XLSX" Input. This Macro doesn't care about the schema. You will need to do some clean up afterwards, but you can easily import everything into Alteryx.

Example:

Tabelle 1:

Tabelle 2:

Workflow:

Results:

The CReW Macros can be downloaded here: http://www.chaosreignswithin.com/p/macros.html

I hope this helps.

Best

Alex