question

As long as you have a reference to the loadstation you compare this reference with a table value in a column by a Table.query, or a member of a Group, or an element of an array.

A table query can return a static number value or a string that you execute to get a dynamic value.

You get from a group or an array the index of a matching member. You use this discrete value to choose a static time or a time value from a statistical distribution of the LoadTime function picklist option Values of Case.

Table.query

The Table:

If you want assign pointer data or references to row, then you set the data type to the column by the right mouse button context menu.

If you activate a cell to write data, you get some tools beside the cell. One is the sampler, which you use to choose the object in the model directly to get the pointer data.

In the Properties window of a transporter you can add a source code that queries the table for the right time. You need the reference to the load station. This is a variable in the source code header named station. It is always available for the code you write into the Load Time function wether in the field or the source code.

Source code:

double loadTime = Table.query("SELECT times FROM tbLoadTimes WHERE queue = $1", station)[1][1];

Indes of array or group

You can create a group in the toolbox. You add members to the group. The order of its members defines the index number you get back if you you are looking for the index.

In the Load Time function you choose from the picklist option Values by Case .

The Case Function must return a discrete number. For each number you can set a different static time value like above in the picture or you can choose a statistical distribution from the options.

Source code directly entered:

Group("loadStations").indexOf(station)

The variable station is still declared in the header of the Load Time function source code editor.

---

An index of an array works the same. But you must assign the objects to an Array. In an licensed version of FlexSim you can use global variable. Otherwise you can use a label at the transporter. I set the elements of the array by a reset trigger code snippet source code:

The Load Time function Case Function looks like this source code of Values by Case:

current.labelLoadStation.indexOf(station)

You can adapt these approaches to Process Flow as well. The station variable will probably be a label at a token.

My favorite is the group approach.

load-times-by-station-list.fsm