SQL Query to fetch data from Global Table and Adding into next column?

Question

question

Ankur A3 asked Jul 24, '22 Ankur A3 commented Jul 25, '22

SQL Query to fetch data from Global Table and Adding into next column?

Hi Team,

I am working on problem where I need to find utilization while providers are having variable working hours over days. What is the best way to approach such case?

24.07.2022_Divide_Based_On_Query.fsm

Thank you!

Software Version:

FlexSim 21.0.10

sql queries utililization variable hours

1658664117919.png (52.7 KiB)

24072022-divide-based-on-query.fsm (32.5 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-07-25T06:14:04Z

Felix Möhlmann answered Jul 25, '22 Ankur A3 commented Jul 25, '22

You can link the rows in tables with shared rows with the JOIN clause.

https://www.w3schools.com/sql/sql_join.asp

In this case you would join the tables based on the 'Day' and 'Provider' columns. Then you can use the 'Working_Hours' column to calculate the utilization in the calculated table.

24072022-divide-based-on-query-fm.fsm

24072022-divide-based-on-query-fm.fsm (38.2 KiB)

· 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.

Ankur A3 commented · Jul 25, 2022 at 12:54 PM

Thank you! @Felix Möhlmann

0 ·

question