How to loop a Macro workflow until the files all completed

[dmwang]

Hi All,

I currently have a Macro workflow that process a single file for each month. It takes a ZIP file appends it into Database and then aggregates it into another database.

However, as all the previous data are incorrect, I have to re-run this for 100 times +

I would like to setup an Iterative Macro that continuously runs the existing workflow which takes FileName_20*.ZIP (20XX for years, 2018 to 2024, etc)

What can I do, thx in advance.

[JosephSerpis · Accepted solution]

Hi @dmwang a Batch Macro might also work in this scenrio as you can feed in the list of files as batches. If you are not familar with Batch Macro would recommend the interactive lessons from the Academy section of the community.