Stefan Posted July 3, 2018 Share 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 Link to comment Share on other sites More sharing options...
dsturrock Posted July 3, 2018 Share 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. Link to comment Share on other sites More sharing options...
Stefan Posted July 4, 2018 Author Share Posted July 4, 2018 Thank you Dave. The second approach works fine! Link to comment Share on other sites More sharing options...
Recommended Posts