question

Gavin D3 avatar image
0 Likes"
Gavin D3 asked Jeanette F commented

Table Query - Simple Question

I apologize for such a simple question. But, I have a table like this:

Machine A Machine B

Op10 10 15

Op20 11 12

where Machine A and B and column titles and Op10 and 20 are row titles.

I would like to write a simple table query that would return the value associated with Machine B and Op20 (12) and set that value to a int var. Seems simple but I've had no luck. -Thanks



FlexSim 22.2.2
tablessql queriestable query
· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Gavin D3, was one of Felix Möhlmann's or Jason Lightfoot's answers helpful? If so, please click the "Accept" button at the bottom of the one that best answers your question. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 Likes 0 ·

1 Answer

·
Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered

If it's a global table then its just:

int myVar=Table("MyTable")["Op20"]["Machine B"];
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.