question

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

How to pivot a table

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

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].