How to: Itterative macro - dynamic input - sql?

[Hamder83]

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?

[atcodedog05 · Accepted solution]

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.

Using iterative would be complicating things.

Hope this helps : )

[Hamder83]

hi @atcodedog05 ,

Your genious!

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

Thank you very much

[atcodedog05]

Happy to help : ) @Hamder83 

Cheers and have a nice day!