Get item in "Write to Table"

Question

question

Fengjun0113 asked Aug 25, '22 Fengjun0113 commented Aug 30, '22

Get item in "Write to Table"

Hello, it is a FlexSim 2016 model. I am trying to read "item" then I can set number to Global Table in "Write to Table". I tried to used "node" to read item but it didn't work. How can I fix it?

https://drive.google.com/file/d/1ENEKjrQ2jK9h68S3pK9Fe529uOZsXSu6/view?usp=sharing

Software Version:

FlexSim 16.1.2

item node write to table

1661387939312.png (196.1 KiB)

Answer 1 · 2022-08-25T06:07:13Z

Felix Möhlmann answered Aug 25, '22 Fengjun0113 commented Aug 30, '22

The items are assigned the name "Product" in the source schedule. So that is the node name you would have to search for.

treenode item = node("/Product",current);

Instead of the name, you can also use the rank to refer to a subnode. So if the item will always be the first subnode of the processor, you can use the following and get a reference to the item regardless of its name.

treenode item = node("/1",current);

· 4

Fengjun0113 commented · Aug 25, 2022 at 06:33 AM

Thank you !

0 ·

Fengjun0113 commented · Aug 29, 2022 at 01:07 AM

Hello @Felix Möhlmann, in this model, I also want to add a column in "WaitStats" to see how many samples for each row. How can I do?

0 ·

1661735160270.png (15.6 KiB)

Felix Möhlmann Fengjun0113 commented · Aug 29, 2022 at 07:41 AM

You should be able to use the "COUNT" SQL-keyword to determine how many entries there are for each processor in the WaitTimes table.

"SELECT COUNT(Process) FROM WaitTimes WHERE Process == ..."

https://www.w3schools.com/sql/sql_count_avg_sum.asp

0 ·

Fengjun0113 Felix Möhlmann commented · Aug 30, 2022 at 07:26 AM

Thank You !

0 ·

question