community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Union all csv files in subfolders with a macro

Asteroid

Hi,

 

I've built a macro where it succesfully unions all csv files in a specific folder. However, I have 50 other folders that contains csv files (all same type), so I need to go one by one to union csv files in each folder with a macro.I just want to have a single output that contains all csv files in 50 folders 

 

Is there a shortcut to this?

 

EX: Folder A

           SUBFOLDER AB--contains 10 csv files

           SUBFOLDER AC--contains 15 csv files

           SUBFOLDER AD--contains 11 csv files

           ....

           ....

 

Instead of setting my macro one by one, I would like to union all csv files under folder A

 

Thanks  (I attached screenshots from my workflow)

Highlighted
Alteryx Alumni (Retired)

Did you know you can use wildcards in the file path, plus there is also a "Search DubDirs" option in the Input tool.

So if all of the CSVs are basically the same structure, you don't really need a macro...you can just have the source file as...

"C:\Directory\Whatever*.csv" and it will input all of the CSVs that start with "Whatever".

Labels