Creating column with relative row index for each row of each record

[Paul Smith]

Dear All,

Consider the following:

RecordID	RowInsideID	Name
1	1	Paul
1	2	Peter
2	1	Mary
2	2	Jane
2	3	Thomas

Given columns RecordID and Name, how could one create the column RowInsideID, which has for each row of each record the corresponding row index starting with 1 for each record.

Thanks in advance,

Paul

[Ettore Rizza]

Hi Paul,

You must first create records using "Blank down" on your ID column, then use this GREL formula:

row.index-row.record.fromRowIndex + 1

Here is a short screencast.

Cheers,

Ettore

[Paul Smith]

Thanks a lot, Ettore. That works!

Paul