How to import data from global table to empirical distribution table

Question

question

Mike asked Aug 18, '23 Jason Lightfoot edited Aug 18, '23

How to import data from global table to empirical distribution table

Hi,

I would like to connect to SQL server from the production line to pull the past one month uptime and downtime data of the machine. Upon accessing SQL server, it looks like data will be imported to global table. Then, how to import the data from global table to Empirical table automatically. That means once the model starts running, model connect to SQL sever and retrieve data then data will be imported to global table then empirical table. Would that be possible? if yes, appreciate if you could help to make a simple example model. Thanks a lot.

Software Version:

FlexSim 23.2.0

global table import empirical distribution

1692319220099.png (94.4 KiB)

Answer 1 · 2023-08-18T06:06:05Z

Felix Möhlmann answered Aug 18, '23 Jason Lightfoot edited Aug 18, '23

You can use the code below to copy the table into the distribution. Just replace the distribution and table names so they match your model.

treenode distributionTable = Model.find("/Tools/EmpiricalDistributions/TestName>variables/data");
Table("TestTable").cloneTo(distributionTable.as(Table));

· 4

Mike commented · Aug 18, 2023 at 08:20 AM

Where should this code be written? Global table>>on reset>> script edit? Thanks.

0 ·

1692346707859.png (56.9 KiB)

Jason Lightfoot ♦ Mike commented · Aug 18, 2023 at 08:23 AM

How often do you need it updated? If it's once then just put it in the script console and run it from there.

0 ·

Mike Jason Lightfoot ♦ commented · Aug 18, 2023 at 08:39 AM

I want to update every time the model runs.

0 ·

Show more comments

question