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?
Solved! Go to 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 : )
hi @atcodedog05 ,
Your genious!
Sometimes the simply solution is stearing you right in the face!
Thank you very much
Happy to help : ) @Hamder83
Cheers and have a nice day!
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |