How to find the rownumber in my GlobalTable by flow item labelmachting?

Question

question

Thomas K4 asked May 07 2021 at 2:53 PM Abdullah A commented May 21 2021 at 8:00 PM

How to find the rownumber in my GlobalTable by flow item labelmachting?

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!

Software Version:

FlexSim 21.1.2

flexsim 21.1.2 label matching to find row in the global table

inkedsc-li.jpg (949.7 KiB)

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2021-05-07T15:25:22Z

Ralf Gruber answered May 07 2021 at 3:25 PM Abdullah A commented May 21 2021 at 8:00 PM

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

· 7

Joerg Vogel commented · May 07 2021 at 6:18 PM

@Ralf Gruber,

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.

2 ·

Ralf Gruber ♦ Joerg Vogel commented · May 08 2021 at 2:21 AM

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.

1 ·

Joerg Vogel Ralf Gruber ♦ commented · May 08 2021 at 6:23 AM

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.

0 ·

Thomas K4 Joerg Vogel commented · May 07 2021 at 8:36 PM

Thank You!

0 ·

Abdullah A Joerg Vogel commented · May 21 2021 at 8:00 PM

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!

0 ·

Thomas K4 commented · May 07 2021 at 5:43 PM

Hi Ralf,

okay thank you for the answer. Now I just don't my mistake :S

Thank you for your help!

0 ·

1620409338785.png (26.6 KiB)

Ralf Gruber ♦ Thomas K4 commented · May 08 2021 at 2:14 AM

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].

0 ·

question