How to synchronize the information in a dashboard to a global table?

[wei_cheng_c]

[ FlexSim 20.1.3 ]

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.

test_1.fsm

[joerg_vogel_HsH]

@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.

[moehlmann_fe · Accepted solution]

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.