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.
@camilatoyonaga Try the macro in this post.
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Import-Multiple-sheets-in-from-one-Excel-file/td-p/840836
@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
Thankssssss @Qiu and @abacon, it worked!
@camilatoyonaga Fantastic, please mark both as the solution so others may find the answer more quickly!
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?
@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.
