How do I create a Record number field in an Inline load

[#1]

Hi All,

I am creating a dynamic inline table. The mock code of the Inline table is as below -

Let vRec = RowNo(); //RecNo()

For vStart = 1 to 10

Table:

LOAD Distinct * INLINE [   

Start, RecNo   

$(vStart), $(vRec) ];

NEXT vStart;

Somehow the RecNo() nor the RowNo() seems to give the record number for each record for the table.

Can you please suggest a way to achieve that?

Regards,

SK

[CELAMBARASAN · Accepted solution]

Try this simple script

For vStart = 1 to 10

Table:

LOAD Distinct *, RowNo() AS RecNo INLINE [  

Start

$(vStart) ];

NEXT vStart;

[Siva_Sankar]

Try these..

Let Rows=NoofRows(Table);

For vStart = 1 to 10

Table:

LOAD Distinct * INLINE [   

Start, RecNo   

$(vStart), $(Rows) ];

NEXT vStart;

Regards.

Siva

[#4]

Thanks a lot. Works perfectly..

Cheers,

SK