Combining Two Calculated Tables via SQL

Question

question

Mark S2 asked Oct 27, '22 Jason Lightfoot commented Oct 29, '22

Hello,

I am trying to combine two calculated tables into one via SQL, however my model crashes when I try.

The two tables are:

CalculatedWaitRoomArrivals

CalculatedEHSArrivals

and turning into:

Join Patient Flows Triage Wait Times

Here is the model just before the crash happens:
New Generic Model for Triage_1.fsm

And here is a previous working version:

Thanks!

Mark

Software Version:

FlexSim 22.2.0

calculated table sql queries

new-generic-model-for-triage-1.fsm (946.3 KiB)

new-generic-model-for-triage.fsm (994.2 KiB)

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.

Answer 1 · 2022-10-27T15:47:32Z

Jason Lightfoot answered Oct 27, '22 Jason Lightfoot commented Oct 29, '22

Does this work as expected?

new-generic-model-for-triage-jl.fsm (951.3 KiB)

· 2

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.

Mark S2 commented · Oct 28, 2022 at 02:11 PM

Ugh, yes. Thank you. So simple a fix, but I would have never figured it out. It still throws an error:

syntax error, unexpected select, expecting ')'

But it works so...

0 ·

Jason Lightfoot ♦♦ Mark S2 commented · Oct 29, 2022 at 01:02 PM

Right, we can avoid that by removing the first set of parentheses:

SELECT * FROM CalculatedWaitRoomArrivals
UNION ALL  
(SELECT * FROM CalculatedEHSArrivals)

0 ·