topic Re: Export Calculated Tables after each replication in Experimenter in FlexSim Forum

Export Calculated Tables after each replication in Experimenter

alberto_f2 — Wed, 10 Nov 2021 10:17:03 GMT

[ FlexSim 21.2.4 ]

Hello everyone,

I am trying to export a csv file containing the data in a "Calculated Table" after each replication of the simulation.

I have checked the box "save statistics data for each replication".

I have inserted a Custom Code at the end of each replication,

And in that code I am trying to export the csv file using the function exporttable(), however, nothing seems to happen after the experimenter's run.

do you know if I am doing something wrong? or if there is a second strategy to follow for this task?

Thanks a lot for the support

Re: Export Calculated Tables after each replication in Experimenter

fapicella — Wed, 10 Nov 2021 15:30:23 GMT

Hi Alberto,

your method is correct but you must change the code in the "End of Replication" trigger. Try with the code in the picture below.

Everytime the Experimenter runs a single replication, it opens and runs the model on a new Flexsim, copies the single replication data on the father model, on the node childexfolder, finally closes the child model.

This trigger infact is executed two time: the first time on child model, than on the father model.

You must export the data table that you need only when the trigger is runned by the child model.

For this reason I use the line 8 of the code.

In the line 15 of the code I suggest to write not only the name of the new file, but the full path of the file that you will have.

In this way you can save on csv file, in a specifi path, your experimenter data.

Also at the end of Experimenter, on view result you can have the possibility to see from Flexsim all this result tables. Go on the tab Statistics Tables, you can find all data tables of the model for all the scenario and replications.

I hope I was helpful.

Re: Export Calculated Tables after each replication in Experimenter

alberto_f2 — Wed, 10 Nov 2021 16:23:53 GMT

Thank you very much, that was very helpful, now it works perfectly

Re: Export Calculated Tables after each replication in Experimenter

JordanLJohnson — Wed, 10 Nov 2021 17:12:05 GMT

Any table in the Statistics Table can be queried with a Calculated Table. Create a new Calculated Table, and on the Calculations tab, click the "Enable Direct Editing" button. Then add a query like this:

SELECT * FROM Experiment.[St1]

Click the Update button to run the query. Then you can export the Calculated Table either in the Excel Export, or you can use the exporttable() command:

exporttable(Model.find("Tools/CalculatedTables/St1"), "data.csv", 1)