Find value in Global Table based on matching label

Question

question

Maryam H2 asked Oct 12 2021 at 2:16 PM Ryan Clark commented Oct 15 2021 at 4:46 PM

Find value in Global Table based on matching label

Hi,

If I created several labels based on patient type and want to look up the times based on each type from a global table. How could I find a matching global table value for a given label value ? In the Global Table I have the same labels for patient types I created at first.

In general how can I access the row header? It seems I cannot define a name for the first column where I have all my labels there.

Thanks!

Software Version:

FlexSim 21.2.3

global tables rowheader label matching to find row in the global table

1634047391598.png (14.6 KiB)

· 1

______

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-10-12T15:26:32Z

Joerg Vogel answered Oct 12 2021 at 3:26 PM Maryam H2 commented Oct 12 2021 at 6:10 PM

Table.getValueByKey(..) method

· 6

Joerg Vogel commented · Oct 12 2021 at 3:31 PM

If you need a string as reference of a header for a column or row, then you should try to use a custom code, because any template or activity has got restrictions to the overload of values.

Table(“myTableName”)[“rowHeaderName”][“columnHeaderName”]

0 ·

Maryam H2 commented · Oct 12 2021 at 4:08 PM

Thanks @Joerg Vogel!

So, If I use custom code and want it to find the value in the global table by looking up the label on the item what should I put instead of “rowHeaderName”? Does it mean the very first column where I have all reference labels there? The header is empty so how should I reference that?

After that, should I write this in custom code?

Table(“myTableName”)[“rowHeaderName”][“columnHeaderName”].getValueByKey(patient.Type)?or just Table(“myTableName”).getValueByKey(patient.Type)?

Also where in custom code, "Set Label"?

0 ·

Felix Möhlmann Maryam H2 commented · Oct 12 2021 at 4:39 PM

If you use Table("TableName")[row][col]" then "row" and "col" can either be the number of row/column or the header of the row/column.

Let's take the following table. I will type out some examples and what value they would return:

Table("GlobalTable1")[2][2]          -> 4   The second row/column are "BBB"/"Even"
Table("GlobalTable1")["BBB"]["Even"] -> 4
Table("GlobalTable1")["CCC"][1]      -> 5
Table("GlobalTable1")[1]["Odd"]      -> 1
Table("GlobalTable1")["EEE"]["Odd"]  -> 9

"getValueByKey" can not be used with the headers and works as follows

Table("GlobalTable1").getValueByKey(4, 1, 2)  -> 3

It returns the value from column 1 (second parameter), in the row where column 2 (third parameter) is equal to 4 (first parameter/key).

In your case, if you have the types as row headers, you'd use

Table("GlobalTable1")[patient.type][col]

2 ·

1634056339807.png (5.3 KiB)

Maryam H2 Felix Möhlmann commented · Oct 12 2021 at 5:04 PM

Thanks @Felix Möhlmann

I have my labels in the first column where you have" AAA, BBB, CCC,..." and times in the second column. So where, should I define that chunk of code? custom code? where in custom code?

If I define it in the processing time, I'll get this error:

time: 453.528860 exception: FlexScript exception: Invalid row number: 0 in Global Table "SCH_Times" at MODEL:/Tools/ProcessFlow/Ortho Patients/MD Visit Process in Orthopedic>variables/delayTimeNode

0 ·

Show more comments

question