We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

kmcgraw2
6 - Meteoroid

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.

4 REPLIES 4
Warcry
9 - Comet

Attached is a workflow that would fit your questions dynamically.

caltang
17 - Castor
17 - Castor

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. 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
kmcgraw2
6 - Meteoroid

I received an error that says that macro can't be found

Warcry
9 - Comet

Did you export everything from the zipped workflow

 

Labels
Top Solution Authors