question

kauan pedroso avatar image
0 Likes"
kauan pedroso asked Jason Lightfoot commented

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.


1679312557558.png

1679312585129.png


FlexSim 21.2.4
global tableimport datasql server
1679312557558.png (51.3 KiB)
1679312585129.png (7.8 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered Jason Lightfoot commented

You can use:

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

and 

Table.query("UPDATE GlobalTable1 Set Difference=OutputTimestamp-InputTimestamp");
· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

kauan pedroso avatar image kauan pedroso commented ·

Hello @Jason Lightfoot

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

1679410448616.png


1679410483821.png

0 Likes 0 ·
1679410448616.png (15.3 KiB)
1679410483821.png (3.9 KiB)
Jason Lightfoot avatar image Jason Lightfoot ♦ kauan pedroso commented ·
Looks like you didn't add a column called Difference.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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