How to reach GlobalTable value from Patient Flow

Question

question

Leah R asked Jun 17, '21 Jeanette F commented Jun 21, '21

How to reach GlobalTable value from Patient Flow

Hi everyone,

Very naive question here but I just cannot seem to make it work.

In my model, I have :

an arrival table where each patient has a unique ID.
a global table where each ID is associated with a ProcessTime
a simple patient flow with a "walk then process" block

How can I reach the right process time for each patient from the patient flow ? I guess it would be the flexsim equivalent of : Process Time = Select ProcessTime From GlobalTable1 where ID = patient.ID

Thanks in advance !

Leah

Software Version:

FlexSim 21.0.0

globaltable patientid

1623913213356.png (14.3 KiB)

1623913236933.png (42.5 KiB)

1623913309038.png (56.2 KiB)

· 1

Jeanette F ♦♦ commented · Jun 21, 2021 at 05:35 PM

Hi @Leah R, was Clair A's or Felix Möhlmann's answer helpful? If so, please click the red "Accept" button at the bottom of one of their answers. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 ·

Answer 1 · 2021-06-17T10:41:34Z

Clair A answered Jun 17, '21

Hi Leah,

The answer of @Felix Möhlmann is perfect and generic.

Here is an alternative, not generic, but specific to the way you filled your global table:

Table("GlobalTable1")[patient.ID/10)]["ProcessTime"]

Since each ID in your table is equal to 10 times the row index.

Answer 2 · 2021-06-17T07:33:13Z

Felix Möhlmann answered Jun 17, '21

The command

Table(string TableName).getRowByKey(Variant key, Variant col)

gets the first row number where the value in column "col" is equal to "key".

So in your case the full expression would be:

Table("GlobalTable1")[Table("GlobalTable1").getRowByKey(patient.ID, 1)]["ProcessTime"]

question