Calculated Tables can not recognize string format correctly

Question

question

jing.c asked Jun 27, '18 Phil BoBo answered Jun 28, '18

Calculated Tables can not recognize string format correctly

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.

Software Version:

FlexSim 18.0.4

calculated table sql queries string

string-format-error.png (87.8 KiB)

· 1

Joerg Vogel commented · Jun 27, 2018 at 08:53 AM

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.

0 ·

Answer 1 · 2018-06-27T14:47:29Z

Phil BoBo answered Jun 27, '18

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:

calculated-table.png (69.1 KiB)

calculated-table2.png (96.8 KiB)

· 1

jing.c commented · Jun 28, 2018 at 12:51 AM

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.

0 ·

question