Consume data from a GlobalTable1

Question

question

kauan pedroso asked Mar 20, '23 Jason Lightfoot commented Mar 21, '23

Consume data from a GlobalTable1

hello

I have a question, thanks to anyone who takes the time to help me. I have a table that pulls data from a sql server, but the order is scrambled and I can't use sql commands to sort that list. The other part of being able to consume this list is to get the input value minus the output value.

Software Version:

FlexSim 21.2.4

global table import data sql server

1679312557558.png (51.3 KiB)

1679312585129.png (7.8 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2023-03-20T15:19:04Z

Jason Lightfoot answered Mar 20, '23 Jason Lightfoot commented Mar 21, '23

You can use:

Table("GlobalTable1").sort("InputTimestamp");

and

Table.query("UPDATE GlobalTable1 Set Difference=OutputTimestamp-InputTimestamp");

· 2

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

kauan pedroso commented · Mar 21, 2023 at 02:55 PM

Hello @Jason Lightfoot

Sorting by dates worked, but calculating input minus output didn't work.

0 ·

1679410448616.png (15.3 KiB)

1679410483821.png (3.9 KiB)

Jason Lightfoot ♦♦ kauan pedroso commented · Mar 21, 2023 at 03:19 PM

Looks like you didn't add a column called Difference.

0 ·

question