topic Re: In load script: aggr & rank in App Development

In load script: aggr & rank

wanyunyang — Fri, 02 Apr 2021 08:08:51 GMT

I have a table with columns: OrderType, OrderNo, ShipmentDays. I would like to rank ShipmentDays within OrderType group.

e.g.

OrderType, OrderNo, ShipmentDays, Rank

Fruit, A, 3, 1

Veg, B, 2, 1

Veg, A, 3, 2

How should I achieve this? Thanks in advance!

Re: In load script: aggr & rank

sunny_talwar — Thu, 17 Oct 2019 17:07:02 GMT

Try this

Table: LOAD * INLINE [ OrderType, OrderNo, ShipmentDays Fruit, A, 3 Veg, B, 2 Veg, A, 3 ]; FinalTable: LOAD *, If(OrderType = Previous(OrderType), RangeSum(Peek('Rank'), 1), 1) as Rank Resident Table Order By OrderType; DROP Table Table;

Re: In load script: aggr & rank

wanyunyang — Fri, 18 Oct 2019 14:12:10 GMT

Hi Sunny,

Thanks for helping! Do you mean Order By ShipmentDays? I was trying to rank ShipmentDays within each OrderType.

Re: In load script: aggr & rank

sunny_talwar — Fri, 18 Oct 2019 14:46:21 GMT

Then add that as well

FinalTable: LOAD *, If(OrderType = Previous(OrderType), RangeSum(Peek('Rank'), 1), 1) as Rank Resident Table Order By OrderType, ShipmentDays;