Batch Input with all different table names

[ultrarunner]

Hi there,

I have multiple Excel files with all different sheet names (or Table names) and try to combine them using Batch Input data: https://community.alteryx.com/t5/forums/postpage/board-id/designer-discussions

My file names are like:

USA file/ USA table, Europe file/Europe table, Asia file/ Asia table

Is there anyway to update "3 Table or Query" name so I could combine all different tables?

I may need to replace the original name ('USA') with something very generic, but not sure what to do next:

Any help will be appreciated.

Thank you,

[christine_assaad]

Hi @ultrarunner 

Would you please try the attached and let me know?

It's a macro inside another macro. The first one will basically import the list of sheets and with a formula, you will be able to feed it with your sheets' names and then the second macro will loop thru the different sheets and pull data.

[pedrodrfaria]

Hi @ultrarunner 

I have attached below the workflow.

This is a batch macro that open every file in the workflow (the macro can be updated to run other type of files, this one is specific to xlsx, let me know if you are working with a different file).

1. You can see 3 different XLSX files I'm trying to read. They do not have the same data format. (They are attached to this so you can see)

2. Load the files

3. You can see that 3 iterations were ran.

4. On the right hand side you can see that we were able to load all the files together

If this was a solution for your question. Please update the post to be closed with an answer.

Pedro.