question

Ankur A3 avatar image
0 Likes"
Ankur A3 asked Ankur A3 commented

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?

1658664117919.png

24.07.2022_Divide_Based_On_Query.fsm

Thank you!


FlexSim 21.0.10
sql queriesutililizationvariable hours
5 |100000

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

1 Answer

·
Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered Ankur A3 commented

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


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

Ankur A3 avatar image Ankur A3 commented ·
Thank you! @Felix Möhlmann
0 Likes 0 ·

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.