Stefan Posted July 3, 2018 Posted July 3, 2018 Dear all, I do have a table called machineProperties which describes properties of machines: Machine | ProcessingTime | ... machine1 | 2 |... machine2 | 1.5 | ... In my model I would like to assign the property "Processing time" to machineProperties(DisplayName;"ProcessingTime"). I guess Lookup tables might be working, but unfortunately I do not know how to link them to an Excel file. Does anyone know how to do this? Thank you! Best regards, Stefan
dsturrock Posted July 3, 2018 Posted July 3, 2018 There are several ways. One very efficient way to to simply hard code the row number for each object. So if Server7 happened to be a type of machine2 (in row 2) its process time expression could be machineProperties[2].ProcessingTime. A bit more difficult is to use a custom server (call it myServer) that has a myRow state. On initialization each myServer would search the table to find its row and store that in its myRow state. Then, its process time expression would be machineProperties[myRow].ProcessingTime.
Stefan Posted July 4, 2018 Author Posted July 4, 2018 Thank you Dave. The second approach works fine!
Recommended Posts