Page 1 of 1

Sampling table functions

Posted: Fri Jul 14, 2017 12:17 pm
by gsimpso4
I have some tables holding estimates of the relationship between an input and an output.

Each table has multiple rows, representing different estimates of the relationship.

Each table is either from SME estimates (few rows) or from business analytics (many rows)

I would like to randomly sample among the rows in my tables, running my model across the samples and compiling distributions of the output.

Is there an example that shows how to do this?

...george...

Re: Sampling table functions

Posted: Fri Jul 14, 2017 8:10 pm
by tomfid
We don't have an example unfortunately. (This is a bit exotic!) We'll ponder how to do it.

The basic idea would be to put the lookup in an entitytype (maybe by itself, one entity per table). You can supply the tables as a data source if you use Excel input (the builtin doesn't support lookups). Then assign your simulation a reference to the required lookup. One way to do that would be to use a Process List action to pick a lookup entity at random, and assign it's ID to whatever entity is using the table.