Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Row ID creation

I have following table:

JS-NoEntry NoRow ID
JS-00111
JS-00122
JS-00133
JS-00174
JS-00245
JS-00256
JS-00267
JS-00298
JS-00389
JS-0031010
JS-0031111

The input fields are JS-No and Entry No. But Bcoz there is a break in the entry no, i want to have RowID. it will first sort on the basis of JS-No and Entry no. and Row ID assigned to the result.

Can anyone help me with this?

Will be great if i get the output in q likview file.

5 Replies
Not applicable
Author

Hi Kartik,

you can just use

Rowno() AS     [Row ID]

in your script to generate that

hope that helps

Joe

its_anandrjs

Hi,

You can use Autonumber() here but can you elaborate more with expected out put.

Load

Js-NO,

[Entry No],

Rowno() as [Row id]

From Source;

Regards

Anand

Regards

Anand

alexandros17
Partner - Champion III
Partner - Champion III

Is this helpful?

AAA:
Load * Inline [
JS-No, Entry No
JS-001, 1
JS-001, 2
JS-001, 3
JS-001, 7
JS-002, 4
JS-002, 5
JS-002, 6
JS-002, 9
JS-003, 8
JS-003, 10
JS-003, 11
]
;

BBB:
NoConcatenate
LOAD * Resident AAA Order by [JS-No] asc, [Entry No] asc;
Drop Table AAA;

CCC:
NoConcatenate
LOAD *, RowNo() as RowNum Resident BBB;
Drop Table BBB;

MarcoWedel

Hi,

one solution as a chart expression:

QlikCommunity_Thread_149421_Pic1.JPG

hope this helps

regards

Marco

Not applicable
Author

Hi,

You can directly add a expression as rowno(),then drag it to first position.

Thanks