Directory Tool to Input Multiple Files - Need to Combine Tabs within these files

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.

Workflow

Datasets

Input

Macros

Accepted answers

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.

All comments

Attached is a workflow that would fit your questions dynamically.

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703