How to pivot a table

Question

question

Marian Cretu asked May 3, '20 Joerg Vogel edited May 4, '20

Hello guys,

I have a table with racks,pallets,sku and I want to find which rack contains the most pallets with sku = 1.

Please advise.

Software Version:

FlexSim 19.1.2

flexsim 19.1.2

pivot-table.fsm (19.6 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 · 2020-05-04T04:41:01Z

Joerg Vogel answered May 4, '20 Joerg Vogel edited May 4, '20

Table.query("SELECT rack_name, sku, SUM(pallets) AS amnt FROM stock \
WHERE sku = 1 GROUP BY rack_name \
ORDER BY amnt DESC").cloneTo(Table("dump"));

I copied the query result into a table called "dump". You find the rack_name of the most counted pallets of sku = 1 in cell [1][1].

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.