Input Loop

[df]

Hello,

I have an Input tool which selects data from an mysql database.

Lets say:
Select * from table where date = '2020-01-01'

Now i would like to run this input multiple times with every date until 2020-05-31

Can this be done with an macro?
(Backround: I can't take date between 2020-01-01 and 2020-05-31 because to load one date into alteryx takes 2 or 3 seconds but to load like 30 days takes hours)

Cheers

David

[danilang · Accepted solution]

Hi @df 

You can use a Dynamic Input and pass in multiple rows, one with each date that you want to retrieve.  Configure the Dynamic Input to "Update the Where Clause "with the new date.  The queries will run one at a time and the results will be unioned together

Dan