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

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"));