How to passe an Experiment.StatisticCollector table as a parameter in a query ?
Table FromTable = ???
/*1)*/ Table Query = Table.query("SELECT * FROM Experiment.SC");
/*2)*/ Table Query = Table.query("SELECT * FROM $1",FromTable);
Query.cloneTo(TableResult);
Something like this will work:
Table.query("SELECT * FROM Experiment.[Staytime Collector]").cloneTo(Table("GlobalTable1"))
You can just construct the string using the stats collector name - you don't need it as a parameter:
Object sc=Model.find("Tools/StatisticsCollectors/Staytime Collector");
Table.query("SELECT * FROM Experiment.["+ sc.name+"]").cloneTo(Table("GlobalTable1"));
You may want to join the taskid on the tasks and scenarios tables to get more useful fields.
Option one is the correct way to query an experiment table:
/*1)*/ Table Query = Table.query("SELECT * FROM Experiment.SC");
It is very common that the table name needs brackets:
Table Query = Table.query("SELECT * FROM Experiment.[SC]");
It is usually unnecessary to pass the table as a parameter, as FlexSim supports nested queries:
SELECT ... FROM (SELECT a, b, c FROM Experiment.SC WHERE ...)
If you really need to query a custom data structure (which could include a table), you can use placeholders and $iter():
Table fromTable = Table("GlobalTable1");
Table result = Table.query("SELECT $2 AS Col1, $3 AS Col2 FROM $1"
, fromTable.numRows /*pass in the number of rows in your table*/
, fromTable[$iter(1)][1] /*use $iter(1) to access the nth row*/
, fromTable[$iter(1)][2]
);
result.cloneTo(Table("GlobalTable2"));
19 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
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.