We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Input Loop

df
8 - Asteroid

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

1 REPLY 1
danilang
19 - Altair
19 - Altair

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

Labels