Running a workflow multiple times with different dates in SQL queries using dynamic input?

[akin_sony]

Hi Alteryx community,

Essentially I'm trying to run a large data intensive workflow where I am trying to extract a year till today's worth of data.

I need to change every input file depending on dates to pull for each month, and then also another column which will be name. Each input file is using a SQL query, which I'd like to automatically update after the workflow has run until it reaches a certain date. ie (Start Date  01/10/2021 end date 01/10/2022

[smoskowitz]

@akin_sony -- I would look at a batch macro for what you suggest. I can't look at it myself, but your use case seems to screen for one. Let me know if this helps!

Seth