How use a Global Table in a query to pull from a list?

How use a Global Table in a query to pull from a list?

tee_hiett
Not applicable
6 Views
2 Replies
Message 1 of 3

How use a Global Table in a query to pull from a list?

tee_hiett
Not applicable

[ FlexSim 21.0.1 ]

covid-19-vaccination-Hoover-Met_2.fsm


@Matthew Gillespie

In adapting this attached COVID-10 vaccination model to an unusual location, I've had to adjust the Observation Lanes. I have built a global table ObsLanesCapacity with the capacity for each lane. I cannot figure out how to use this table in the query to Pull from Observation Lanes in the Wait for Observation content box. My latest attempt is WHERE Lane == Puller.LaneNum AND queueSize < Table("ObsLanesCapacity") [1][Puller.LaneNum]."


Thanks for your help


0 Likes
Accepted solutions (1)
7 Views
2 Replies
Replies (2)
Message 2 of 3

parker_s
Not applicable
Accepted solution

I believe an easier solution would be to store the Observation Lane capacity as a label on the Lanes themselves and include that label on your "ObservationLanes" list. Then your query would be this:

WHERE ObservationLanes = puller.LaneNum AND queueSize < Capacity

support_covid-19-vaccination-hoover-met-2.fsm

0 Likes
Message 3 of 3

tee_hiett
Not applicable

Thanks, @Parker S Nice solution!!!! Now, how can I get cars from the Vacation10 or Vacation2_10 spots go to ObservationLane10 Or ObservationLane11 whichever has the fewer cars?

0 Likes