Start Free Trial

Alteryx Designer Desktop Discussions

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

How to: Itterative macro - dynamic input - sql?

Hamder83
11 - Bolide

Hi 

I have an idea, but no idea how to make it.

I want to extract a lot of data from our sql system. And instead of doing one big massive load i want to:
Define a start date ex. 2021-01-01

Then I want to loop through the data 5 days at the time.

But instead of having to update my sql every time, i was hoping i could add this to a macro - and use the dynamic input to loop ?


But, I dont have enough experience to do this?


3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @Hamder83 

 

Just create 5 days date using row gen tool and pass days has key paramter to dynamic input tool. Then dynamic input tool will run for each row and give 5 days data.

 

atcodedog05_0-1646814862911.png

 

Using iterative would be complicating things.

 

Hope this helps : )

Hamder83
11 - Bolide

hi @atcodedog05 ,

Your genious!

Sometimes the simply solution is stearing you right in the face!

Thank you very much

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Hamder83 

Cheers and have a nice day!

Labels
Top Solution Authors