Data source for calculated tables

Question

question

laetitia thomas asked Nov 22, '18 Jordan Johnson answered Nov 28, '18

Data source for calculated tables

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.

Software Version:

FlexSim 18.2.2

sql calculated table bundle labels

Answer 1 · 2018-11-28T22:23:18Z

Jordan Johnson answered Nov 28, '18

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.

question