how to get data from globaltable3 into schedule source.
without using excel to input.thank you!
There are examples of this in the forum. Use a Table query on the GlobalTable data to cloneTo the schedule table. The arrival schedule of the source can be accessed with an expression like this:
getvarnode(Model.find("Tools/ProcessFlow/ProcessFlow/Source"), "arrivals")
Make sure the format is correct for the Scheduled Source activity to recognise it.
Thank you for answering the question, but where am I supposed to open that I can enter that code?
That expression just gets the node to which you will clone the table and will be just part of the code needed.
You can trigger your complete code as the model resets or you can run a script manually using the script editor.
The two lines of code might be:
treenode arrivals=getvarnode(Model.find("Tools/ProcessFlow/ProcessFlow/Source"), "arrivals");
Table.query("SELECT Time,'' AS Name, Quantity, Mylabel FROM GlobalTable1 ORDER BY Time ASC").cloneTo(arrivals);
Example with that in a script window attached.
13 People are following this question.
