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.
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.
Some notes on these methods' speed with large tables (eg.10000 rows)
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.
Table(GlobalTable1).getRowByKey(token.Type, 1)
7 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
