Hi everyone.
I met a problem when use Calculated Tables to show some information from entries in Global List.
As the pic below.
The "code" column in Entries is String, but It shows number in result of Calculated Table which make some string data miss.
Can anyone tell me how to enforce a column with specified format or how to solve this problem?
Any advice will be appreciated.
If it is a global table, you can mark the column and set the column to as string by the context menu (right mouse button click).
Otherwise you can add an underscore "_" as a prefix to each value. When you process the data you remove the first character in the string.
What is configured on the Display Format tab of your calculated table?
Please post an example model demonstrating the issue so we can replicate what you are seeing and explain how to change it.
It seems to be working fine to me:
Thanks for your reply! @phil.bobo @Jörg Vogel
I found out the problem. The data is imported from an excel file through "Excel Import/Export", and it can not recognize all data format correctly. Especially when it comes the string one begin with number.
It still seems strange that the "code" from the label of item, and It shows normal in Entries Table(shown in the question detail) but strange in Calculated Table.
8 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.
