Consolidate multipe tabs with different names in an excel file

[camilatoyonaga]

Trying to consolidate different sheets with different names using Dynamic input. Error is different scheme. Tried doing a bath macro but getting an error as well. 

[Qiu · Accepted solution]

@camilatoyonaga 
Try the macro in this post.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Import-Multiple-sheets-in-from...

[abacon · Accepted solution]

@camilatoyonaga Another option is this macro below, it uses batch macros to read in the sheet names from each file in the folder and pull the data out into 1 data stream.

Dynamic XLSX Input Tool 

Bacon

[camilatoyonaga · Accepted solution]

Thankssssss @Qiu  and @abacon, it worked!

[abacon · Accepted solution]

@camilatoyonaga Fantastic, please mark both as the solution so others may find the answer more quickly!

Bacon

[camilatoyonaga]

Hi @Qiu the macro isn't working today, please see attached. Can you please let me know how i can safely use this moving forward on my workflows? 

[Qiu]

@camilatoyonaga 
The error indicates that the workflow can not locate the macro anymore, either the workflow or Macro is moved I believe.
So you can either provide the new location of the macro or insert the macro again from the work flow as below.