hwjeon Posted January 23, 2016 Share Posted January 23, 2016 Hi, I'd like to build a model with arrival and processing times in data tables. I figured out how to create arrivals based on a table - setting arrival mode on a source object into Arrival Table and linking the table column to Arrival Time Property. A real problem is about how to link processing times in a data table to a server object. I set Processing Time of a server object as the table column, but it doesn't work. I know this is a row reference related error, but I don't want to have the RandomRow option, since the processing time should be selected for each entity in the order of processing times in the table. To make a long story short, I have two tables, each of which is for arrival and processing times. Arrival table.Arrival = 0.1, 0.2, 0.3, 0.4, 0.5 Processing table.Proc = 0.05, 0.06, 0.07, 0.08, 0.09 The 1st entity should be created at 0.1, and its processing time should be 0.05. The 2nd entity should be created at 0.2, and its processing time should be 0.06. The 3rd entity should be created at 0.3, and its processing time should be 0.07. The 4th entity should be created at 0.4, and its processing time should be 0.08. The 5th entity should be created at 0.5, and its processing time should be 0.09. For your information, the file has been attached to this post. Anybody can help me with this? Thanks a lot in advance!! Test_Model.spfx Link to comment Share on other sites More sharing options...
CWatson Posted January 23, 2016 Share Posted January 23, 2016 One easy way to do this would be to create a second 'Real' type column within the first table, Table1, named Proc (like the Table2 column) which includes the minutes for processing corresponding to each arrival time. Then, within the Server Processing Time property, use Table1.Proc (newly created column). When the entity is first created using the Table1.Arrival column for the arrival time, that entity has then an associated row in that table. Therefore, when you reference Table1.Proc, it will use that entity's corresponding row. Alternatively, to use the two separate tables, you would need to first set the entity row reference for Table2 (perhaps using a SetRow step within a process based on the entity as it enters, such as SetRow - Table Name = Table2, Row Number = Source1.EntityArrivals.EventCount, which is the 'count' of entities as they are created). Link to comment Share on other sites More sharing options...
hwjeon Posted January 23, 2016 Author Share Posted January 23, 2016 Thank you so much. The problem fixed! Even when I was posting the question, I believed that this shouldn't be that difficult, and it turned out to be true. Thanks again!! Link to comment Share on other sites More sharing options...
Recommended Posts