question

laetitia thomas avatar image
0 Likes"
laetitia thomas asked Jordan Johnson answered

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.

FlexSim 18.2.2
sqlcalculated tablebundle labels
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Jordan Johnson avatar image
0 Likes"
Jordan Johnson answered

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.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.