Have you tried to put the times you want the workflows to start in a table (you might create this table dynamically) and then use a Loop that would activate the wait node.
@USCHUKN1ME you could try and use a:
and see if you could integrate that with the Wait node. You might have to add a dated but I have not tried that yet.
About Loops in general there is this collection:
Hi @mlauber71 ,
thank your for the tipp.
I have a look to:
Loop example
What must the parameter settings be so that the loop processes all
three lines of the table and passes the start time contained therein to the wait
node?
Table-Creator
Loop Node Settings
Wait-Node Settings?
Thx in advance
greetings
@USCHUKN1ME you could take a look at this example. It uses the current execution time and adds 25, 45, and 65 seconds and then waits until the new shifted time has been reached.
Please note: If the time of day has passed when the workflow reaches the Wait node it will wait until the same time next day!
@mlauber71 thank you.
I will try it.
Where do I have to place the Node LOOP-End? Since I have a
component at the end l’m not sure!
greetings
@USCHUKN1ME you can put a Loop End at the end where what you want to do is finished. If you do not want to collect data but just to end the loop you could use:
Then I would encourgae you to learn about Loops
@mlauber71 thank you !
I set a loop-end node to this position:
I guess it was wrong an di have to use the Variable Loop End Node?!
Loop end would collect the data that comes its way. Variable Loop End would just end the loop and would collect Flow Variables (so you could continue some other tasks afterwards or hand down information from within the loop) - the data handling would have to be done separately within the loop (save to database or disk).
In your screenshot the loop end is within the component. Question is if you want that you would want the component to finish. So it might be better to place a Loop End outside.
ok understand.
If I patch the node inside the component, it “only” terminates the component but not the workflow.
But the component is also part of the workflow - where do I set the loop end node correctly then?
greetings
@USCHUKN1ME you will have to have everything that should happen within one iteration of a Loop within the loop. If you have a more complicated setting that might involve some trial and error. And you will have to make sure to ‘reset’ scything you want to be new/resetted at the beginning of each iteration. If you want to transfer information from one loop iteration to the next there are the Recursive Loops (which I still somewhat struggle to grasp ).
If you want to store intermediate information you can -well- save that as a table and read it back in the next iteration (not the most elegant of solutions).
Then I would suggest you familiarise yourself with the concepts of Loops and Flow variables in general
@mlauber71 hello again
The problem for a beginner, with such large workflows, is to understand why Node A,B,C,… are required for the loop nodes or perform other functions.
Loop Start
Loop End
How to arrive at this configuration is not (yet) revealed to me!
I always think of a loop node an if… then… else or a for… to loop.
But I think that’s wrong!
greetings
If then else is another matter and there are other nodes for that.
With loops there are tow important End nodes.
- one would collect i a KNIME table whatever output is there (you can allow changing structures)
- the variable Loop end would just end whatever is within the loop and just store flow variables with possible informations in them
My impresssion is that you might want to take a step back to the drawing board and make a plan what you want to achieve and familiarize yourself with some KNIME nodes and concepts mentioned in this thread.
Regarding automation / scheduling you have these options
- KNIME server (possibly via AWS)
- Batch mode via CRON or Task Manager
- a wait construction I showed above
actually, it’s relatively simple.
I have a database query and a workflow behind it (end with output of a graphic/dashboard + sending an email). I want to restart the database query + workflow at three predefined times without having to manually reset and rerun the individual nodes.
Start:
Workflow after DB Query Node
End of the workflow in the component
My Question?
Which loop node is the right one for this ?
Is it the Wait Node with a Table creator Node before?
Sorry - which one do you mean?
Next try , again via the WAIT node. Have now built something about
the task scheduling of Windows, which Starts a batch file which creates
a simple text file and overwrites each time. I configured the WAIT node
in KNIME to wait for the modification of a file and then execute it. That worked.
I try to start the subsequent wokflow behind the WAIT node via a LOOP node.
Stupid about the WAIT node is, that it is only executable once and cannot be controlled with it.
Or is there any way to control the WAIT-Node?
If anyone here has a bright idea I am very grateful for a tip.
greetings