Hi! In the GlobalTable2, i have a list of all available articlenumbers (Artikelnummer). So when the flowitem arrives in the rack, I want to write in my GlobalTable2 in the second column the amount, so +1 for each. For this I have to match the label item.Artikelnummer to the Artikelnummer (values in the first column) in the Global Table, to find the row.
What do I have to write in the marked line? Picture below
Maybe someone can help me with this.
Thank you!
Hi Thomas,
there is no picklist option to find a matching global table value for a given label value. I suggest you get familiar with the use of SQL in FlexSim:
User Manual/Reference/Developer and Advanced User Reference/SQL
The function you will have to look at is ROW_NUMBER(). So, this is not a single line of code, but rather a little piece of code where you also will have to consider:
- that now match is found
- that more than one match are found
Good luck
Hi @Thomas K4, I think you need the method of table getRowByKey.This method returns the row number of a table matching the key value of a column.
Table(“GlobalTable2”).getRowByKey(item.Artikelnummer,1)
I assume all Artikelnummern are in column 1. If it is so, you would not need to declare the column though.
I do agree that getRowByKey is the easier method, assuming your SKUs (Artikelnummern) are unique in the table. If you have the same SKU in two different rows the first match will be returned. If the SKU is not found at all 0 will be returned.
Alternatively you can move your found row depending on a condition to the end of your table. If you search the table again for a same SKU (Artikelnummer) you find the next occurring cell. @Ralfs' answer has got more opportunities to filter found rows for items in a slot or age of content.
Just want to give a HUUUGE Thank you! This solved a similar problem I had.
THANK YOU!!!!
You can tell by the CAPS that this problem was very frustrating!
Hi Ralf,
okay thank you for the answer. Now I just don't my mistake :S
Thank you for your help!
You are missing the closing bracket for GlobalTable(...
And GlobalTable is not a Command. You have defined a table object "GlobalTable2" in line 23, so you can use it as GlobalTable2[row][col].
14 People are following this question.
© 1993- FlexSim Software Products, Inc. All Rights Reserved.
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.
