Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Union Folder

navypoint16
8 - Asteroid

Are you able to use an entire folder of .xlsx files as your input and then union them into one file?  I'm finding this works for csv files, but having trouble making it work for Excel.

 

Thanks!

5 REPLIES 5
MarqueeCrew
20 - Arcturus
20 - Arcturus

@navypoint16,

 

Try using this macro published by @CameronS.  It should work wonders for you.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
navypoint16
8 - Asteroid

Thanks for sharing!

 

I'm not sure I know how to leverage the macro for my own use.. it opens as a flow between an excel file opener and a browse.  Am I missing something?

 

Thanks

MarqueeCrew
20 - Arcturus
20 - Arcturus

You should be able to point to the directory that has all of the excel files and it will read all of your files in one tool.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
navypoint16
8 - Asteroid

How do I drop my own excel files into that directory?  It looks like it's filled with sample data.. I'm not able to manipulate it within the workflow.

DavidxL
9 - Comet

When you click on the macro, use the Browse button and select your own directory.

Labels