How to add a sequence number for every group in the straight table?

[#1]

Hello everybody,

I have a table as below, I would like to add a sequence number for every group into the straight table as below, do you have any suggustion? Thanks.

LOAD * INLINE [
    Group, Member, Amount
    G1, A, 100
    G1, B, 100
    G1, C, 100
    G2, D, 100
    G2, E, 100
    G2, F, 100
    G3, G, 100
    G3, H, 100

];

Group	Member	Seq	Amount
G1	A	1	100
G1	B	2	100
G1	C	3	100
G2	D	1	100
G2	E	2	100
G3	F	1	100
G3	G	2	100
G3	H	3	100

[selvakumarsr]

Try RowNo() with Condition..

Selva

[its_anandrjs]

You have to try this way

LOAD *,AutoNumber(recno(), Group) as Seq;

LOAD * INLINE [

    Group, Member, Amount

    G1, A, 100

    G1, B, 100

    G1, C, 100

    G2, D, 100

    G2, E, 100

    G2, F, 100

    G3, G, 100

    G3, H, 100

];

And you get out put as

[PradeepReddy]

Add an expression,  '=rowno()' in chart

Regards

Pradeep

[fkeuroglian]

Hi,

use Autonumber() or RowNo function in the load script

Good luck

[#6 · Accepted solution]

Thank you guys.

As the row number should be changed base on the current selection, as i can't set the number in the loading script.

I have soloved the issue with using aggr and rowno() as below.

aggr(

rowNo()

,group,member)

Thanks.