Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (2)
1 Solution

Accepted Solutions

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

Try this simple script

For vStart = 1 to 10

Table:

LOAD Distinct *, RowNo() AS RecNo INLINE [  

Start

$(vStart) ];

NEXT vStart;

3 Replies

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

Try this simple script

For vStart = 1 to 10

Table:

LOAD Distinct *, RowNo() AS RecNo INLINE [  

Start

$(vStart) ];

NEXT vStart;

Siva_Sankar
Honored Contributor

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

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

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


Thanks a lot. Works perfectly..

Cheers,

SK