Hello,
I am using the pointer string data in my global table to read the object as a destination for my parts. As there will be a huge data, I am using excel import to import all the data to the global table. But, when I import "Destination " column (which needs to be pointer string data) it does not get imported as a pointer string data but as a text. I am manually setting each column as pointer string data.
How to do this? Please help.
In the post import code use the string value to find the object and set the cell value to point to that. You may be able to do it with a single SQL update statement joining on the Objects() table.
can you tell me what is the Objects() table? I did not understand how to do this using a single SQL update statement.
If you have this in the model:
Then the replacement query would be:
Table.query("UPDATE GlobalTable1 a INNER JOIN Objects() b ON b.Object.name==a.ObjectRef SET a.ObjectRef=b.Object");
..which results in this table:
In more complex, hierarchical models you may want to match on the full path rather than just the name.
Unfortunately - you need version 20.2 or later for this to work.
I am bound to use the flexsim version 20.0.10 for my simulation modelling. Can you please tell me an alternative for the same?
13 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.