I'm using a directory tool to input multiple files within a folder. Some as xlsx and some are xlsb. There are three tabs within each of these files that I need to combine. However, they are all named differently (based on the month).
For example, 2019 Q1 File includes these tabs: A3a. JE 314 Feb, A3b. JE 314 Mar, A3c. JE 361. 2019 Q4 file includes these tabs: A1a Oct JEs, A1b Nov JEs and A1c Dec JEs. I'm looking for the most efficient way to combine all of these tabs despite the different names.
Solved! Go to Solution.
I would recommend a batch macro approach here: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309
You can filter the .xlsb out and .xlsx out, then have separate macros (for .xlsb and .xlsx) run them and Union the data as well.
I received an error that says that macro can't be found
Did you export everything from the zipped workflow