I used SQL syntax to organize the data for display on a dashboard, and I am wondering if there is a way to synchronize the information on the dashboard to a global table.
Thank you for your advance.
How to synchronize the information in a dashboard to a global table?
FlexSim 20.1.3
@Liam Chiu, SQL works in background with tables. You should be able to use SQL to output an result table, that you can clone to be shown in a global table.
Might I ask why you even want the data in a global table, when you already have it in a dashboard and calculated table?
As Jörg said in his comment, you can clone the calculated table to the global table:
"Table.query("SELECT * FROM CalculatedTable1").cloneTo(Table("GlobalTable1"));
For example in the On Row Finished trigger of the statistics collector, so the global table is always up to date. Though as I said, I don't really see the point of doing this.
14 People are following this question.
