Based on order history how to create aggregated orders in global table

Question

question

SudheerReddy asked Sep 8, '23 Felix Möhlmann edited Sep 8, '23

Order history

From above order history global table how to create below aggregated orders.
Below is the aggregated orders image

Software Version:

FlexSim 23.2.0

gloabal table

1694144935562.png (42.1 KiB)

1694144963194.png (56.2 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-09-08T06:29:00Z

Felix Möhlmann answered Sep 8, '23 Felix Möhlmann edited Sep 8, '23

Table.query("SELECT Time, [Order ID], ARRAY_AGG(ROW_NUMBER) AS Rows FROM OrderHistory GROUP BY [Order ID]").cloneTo(Table("AggregatedOrders"));

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.