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?
Consume the time of a list
FlexSim 21.2.4
That's not enough information for an answer - please explain more about the process and data; upload your model; explain what the difference column should be used for (transform how?); include a snapshot that actually includes the difference.
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:
current.differences.shift()
Hello @Jason Lightfoot
I managed to filter the data, but I didn't understand how I can use this in my robot's time. Can you show me an example of this ?
1. Table("GlobalTable1")[duniform(1, Table("GlobalTable1").numRows)][7]
I tried to do it that way, but when it reaches 32 cycles it ends up crashing.
That looks more like you're wanting to sample the process time rather than replicate the process time sequence you had in data. For that you can use the Empirical Distribution.
To get the data in there from your global table use something like this:
Table.query("SELECT difference as Data FROM GlobalTable1").cloneTo(Model.find("Tools/EmpiricalDistributions/EmpiricalDistribution1>variables/data"));
Sorry for my English, but actually I want to replicate the process time and not a sample, but I don't know how I can do that. I'm trying with your code above, I'm getting an error.
Hi kauan, i think you can use the calculated table to put the difference time of your columns. 
Probably you can use subset or partitions to filter by day and time.
The Calculated Table (flexsim.com)
Hello @Yumi Nishijima
So I already have the difference value in my table but I was wondering how can I use the difference column values for my robot and the other would be how to filter my InputTimestamp by seconds or date. I saw that you put the Calculated Table option, how can I consume this calculated table and how to filter the seconds or date I want.
15 People are following this question.
