I have a question regarding to 30 minutes time incremental.
I have REST API workflow which works pretty well. As an input I use start date and end date.
For example: start date: 2021-04-01T00:00:00 end date: 2021-04-30T23:59:59
REST API gives me back what I am asking for, but only 500 lines not more. Complete month has definitely more than 500 lines. I know there is in 30 minutes period never more than 500 lines. Due to this fact I need to split the whole month into 30 minutes periods and send more REST-API commands. Not just one for complete month, because I would receive ONLY 500 lines again. I have investigated REST-API has its own limits.
At the end I don’t send only one commands, but 30 days x 24 hours x 2 = 1440 commands separately and at the end collect complete month.
But how to create loop increasing my start date by 30 minutes till end date?
I look for something like this:
2021-04-01T00:00:00
2021-04-01T00:30:00
2021-04-01T01:00:00
2021-04-01T01:30:00
.
.
2021-04-30T23:30:00
The first part only build the table only for the days (e.g. 2021-04-01, 2021-04-02, etc.)
and the second task to build the time scheme for only 1 day (e.g. 00:00, 00:30, 01:00, etc.)
and the use the cross-joiner-node to combine both tables?
Hi @sm0lda Your problem, if I understand it correctly, is very similar to this one from a few days ago, and I suspect my solution to that would be similar for you
I have attached a modified version of that workflow
Hi @sm0lda
As @takbb your question is very similar to a question asked yesterday. And as KNIME has multiple options to solve almost everything. Here is an example using a loop. 30_minutes_incremental_loop.knwf (28.3 KB)
The Counting Loop, creates x new time stapmp with an interval of (in this case) 30 seconds.
Just one of the few times I can actually contribute here
As far as I have seen you have become one of the main contributors to this great community. (No matter the topic! ) I am always curious about the solutions you come up with next.
I really appreciate your posts and hope you will continue helping all of us here.
That’s very kind of you Daniel. I hope that mostly my answers are on the right track and don’t miss the point too much. I’m sure that for many of my solutions Knime has a better way that I don’t yet know about, but I also like reading other people’s solutions to the same problem (and other problems) as so often I then discover a different angle, or feature that I didn’t know about.
There’s plenty of questions asked that I can’t answer, especially when they are in more specialist areas, but I still like to read them anyway.