question

kauan pedroso avatar image
0 Likes"
kauan pedroso asked Jason Lightfoot edited

Consume the time of a list

Hello !

I would like to take the time from my column called difference and transform my operating time of my robot. It is possible ? and yes, how to continue a line flow?


FlexSim 21.2.4
global tabledatabasesql server
· 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.

Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered Jason Lightfoot commented

When you import your data use standard SQL to filter the range of values.

Once the data is in a FlexSim table you can use (via a Table query) ARRAY_AGG(difference) to create an array of values which you put on the processing object/robot (as a label) when the model starts and then you can just put in the time field:

  1. current.differences.shift()
· 6
5 |100000

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

Yumi Nishijima avatar image
0 Likes"
Yumi Nishijima answered kauan pedroso edited

Hi kauan, i think you can use the calculated table to put the difference time of your columns.
1680027184760.png
Probably you can use subset or partitions to filter by day and time.
The Calculated Table (flexsim.com)


1680027184760.png (48.2 KiB)
· 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.