Data source for calculated tables

[laetitia_thomas]

[ FlexSim 18.2.2 ]

Hi,

In the query field of a calculated table, for the FROM statement, I want to use a table that is stored in a bundle label.

I am able to do so in flexscript using the following code :

Table.query("SELECT * FROM $1",MyObject.labels["MyLabel"].as(Table))

But I do not see how I can use such parameters in the query field of the calculated table ?

Thanks for the help.

[JordanLJohnson · Accepted solution]

Calculated Tables don't allow you to specify those parameters. They are designed to operate on globally accessible tables (Lists, Statistics Collectors, other Calculated Tables, Global Tables, and some experiment data).

If your goal is to get the label table as an output, you can use a Statistics Collector to do that. If you post a model, and describe what you would like the output table to look like, we should be able to help you get where you are trying to go.