lookup by value

[sherry_x]

[ FlexSim 22.1.0 ]

I have the type on item, and I hope it set a newlable correspond to item.type, ex: type=2 then it lookup the value 2 is in row1 , so it set the newlable value is 8.

Now , if type=2, my model will lookup row2 to set newlable is 7 , but that's not what I want.

Can I do that? Thank you.

[FelixMoehlmann · Accepted solution]

The command "Table().getRowByKey(key, column)" will return the row number of the first row in which the value of "column" is equal to "key". You can use this to find the correct row based on the label value.

Alternatively, you could duplicate the "type" column and use those values as the row headers. You can then directly refer to the correct row by converting the label value to a string (row headers are always text).

The screenshot shows the On Entry trigger of a queue. But you can of course use this elsewhere as well.

[jason_lightfoot_adsk]

Some notes on these methods' speed with large tables (eg.10000 rows)

• Slowest (x1) is getRowBykey with node based tables
• Next fastest (x4) getRowByKey with bundled data or rowheaders with node tables.
• Fastest (x1000) getRowByKey with bundle data and field index.

So if you're using getRowByKey and can use bundle data it's worth flipping the switch to that type for an x4 speed boost, and if possible add an index for x1000.

[sherry_x]

Thank you all!!

[sherry_x]

Could I use getRowByKey in token?

[FelixMoehlmann]

You can use the command anywhere in the model, including Process Flow and pass in the key via a token label, for example.

Table(GlobalTable1).getRowByKey(token.Type, 1)