In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to loop a Macro workflow until the files all completed

dmwang
6 - Meteoroid

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.

1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor

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.

Labels
Top Solution Authors