Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Try this simple script

For vStart = 1 to 10

Table:

LOAD Distinct *, RowNo() AS RecNo INLINE [  

Start

$(vStart) ];

NEXT vStart;

View solution in original post

3 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Try this simple script

For vStart = 1 to 10

Table:

LOAD Distinct *, RowNo() AS RecNo INLINE [  

Start

$(vStart) ];

NEXT vStart;

Siva_Sankar
Master II
Master II

Try these..

Let Rows=NoofRows(Table);

For vStart = 1 to 10

Table:

LOAD Distinct * INLINE [   

Start, RecNo   

$(vStart), $(Rows) ];

NEXT vStart;

Regards.

Siva

Not applicable
Author


Thanks a lot. Works perfectly..

Cheers,

SK