Table Query - Simple Question

Question

question

Gavin D3 asked Sep 28, '22 Jeanette F commented Oct 3, '22

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

Software Version:

FlexSim 22.2.2

tables sql queries table query

· 1

5 |100000

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

Jeanette F ♦♦ commented · Oct 03, 2022 at 06:05 PM

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 ·

Answer 1 · 2022-09-28T11:28:51Z

Jason Lightfoot answered Sep 28, '22

If it's a global table then its just:

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

5 |100000

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

question