In my attached model, I go to the experimenter > view results > statistics table > select from drop down "duration of procedure phases". How do I export ONLY this table to excel? When I export, there is do much data with so many tabs...how do I limit what is exported to only this table?V4_20230207.fsm
You can read the table into a global table and export from there:
treenode experimenter = Model.find("Tools/Experimenter");
Database.Connection db = function_s(experimenter, "getDBConnection");
int disconnect = 0;
if (!db.isConnected) {
if (!db.connect()) {
return 0;
}
disconnect = 1;
}
Database.ResultSet results = db.query("SELECT * FROM [/Duration of Procedure Phases]");
results.cloneTo("DurationOfProcedurePhases");
if (disconnect) {
db.disconnect();
}
Note that the use of function_s means it may not be supported in the future and you would have to change any code that relied on that function should it cease to function correctly.
Ok, I went to the "advanced tab" on the experimenter, selected "at end of job" and added a "code snippet" and put the code in there. But the results did not appear in a global table. I get the error, "exception: FlexScript exception: Invalid row number: 1 in <no path> at MODEL:/Tools/Experimenter>variables/onEndOfJob"
In addition to my comment below, how is it exported from a global table?
You can probably also use a local result table and export that using an exporttable command rather than having loops to fetch each record and write individual cells.
13 People are following this question.
© 1993- FlexSim Software Products, Inc. All Rights Reserved.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
