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

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 : )

5 days.yxmd