flag row with same item in a series

[Anonymous]

I have a table with sku repeating in multiple rows. I want to flag each row for a particular sku in a series like 1,2,3..

Any help much appreciated.

SKU	Sup_Qty	flag
323	36	1
323	8	2
323	4	3
321	5	1
321	1	2

stalwar1‌

[sunny_talwar · Accepted solution]

You want this in the script?

May be like this:

LOAD SKU,

          Sup_Qty,

          AutoNumber(RecNo(), SKU) as Flag

Resident ....

Order By SKU, Sup_Qty Desc;

Not sure if you want to order the Sup_Qty in the descending order or not, but you can remove the Sup_Qty Desc from the above code, if you don't want that and number according to the order of data.

[Anonymous]

I got it. Thanks