Can I use a macro to repeat the same actions for each file that is read from a folder?

Question

I set up a workflow that has some filtering, sampling, transposing, multi-row formulas etc etc. for one file which is one month of data.

I now have the same file repeated 9 times for all the other months in the year and want to perform the same workflow actions separately for each file, and then union the results at the end.

I've only read about macros but never applied it myself. Is this something I can achieve with a macro?

Appreciate any help! Thank you

Qiu · Answer

@Crispy131 
Using Macro is one option.

Another approach would be using the Dynamic Input to bring the data all in once then do the necessary processing once.

https://knowledge.alteryx.com/index/s/article/Input-Multiple-Excel-sheets-with-a-Dynamic-Input-tool-1583459117180

Gawa · Answer

@Crispy131

You can go with Batch macro.

You can start from here.

https://knowledge.alteryx.com/index/s/article/Getting-Started-with-Batch-Macros-1583461640393