topic Re: dempirical on a query in FlexSim Forum

dempirical on a query

guiroehe — Wed, 28 May 2025 17:06:46 GMT

Hello,

Is there a way to apply dempirical on a table query? I am not getting the expected result.

I can create a function to mimic dempirical, but this seems overkill.

Thank you for any help.

Re: dempirical on a query

regan_blackett — Wed, 28 May 2025 19:16:11 GMT

dempirical() only accepts table references that are either a named global table (str), stored in a node in the tree (node), or a ranked global table in the Toolbox (num). It does not appear to have been updated to include in-memory tables created by Table.query() or members of the Table class. Instead of passing your Table variable t into the function, use the name of the Global Table that you used cloneTo() with. For Example,

demprical("GlobalTable2");

Re: dempirical on a query

guiroehe — Wed, 28 May 2025 20:27:10 GMT

Thank you, but this is not what I was looking for. The example above is to highlight that using "t", the query, does not produce the expected results, despite it is a "Table" variable.
I made it work by creating a dynamic label in the object when the simulation starts, setting it as a bundle, and cloning the query results to that label. Honestly, a lot of overkill.
It would be nice if dempirical:
- would support queries as inputs
- would allow one to choose the column to be used to draw the percentages for the selection
None is very hard to implement.
Thank you anyway.