topic Row ID creation in QlikView

Row ID creation

Fri, 23 Jan 2015 10:42:07 GMT

I have following table:

JS-No	Entry No	Row ID
JS-001	1	1
JS-001	2	2
JS-001	3	3
JS-001	7	4
JS-002	4	5
JS-002	5	6
JS-002	6	7
JS-002	9	8
JS-003	8	9
JS-003	10	10
JS-003	11	11

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.

Re: Row ID creation

Fri, 23 Jan 2015 10:47:54 GMT

Hi Kartik,

you can just use

Rowno() AS [Row ID]

in your script to generate that

hope that helps

Joe

Re: Row ID creation

its_anandrjs — Fri, 23 Jan 2015 10:48:06 GMT

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

Re: Row ID creation

alexandros17 — Fri, 23 Jan 2015 10:48:22 GMT

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;

Re: Row ID creation

MarcoWedel — Fri, 23 Jan 2015 12:01:47 GMT

Hi,

one solution as a chart expression:

hope this helps

regards

Marco

Re: Row ID creation

Fri, 23 Jan 2015 12:09:00 GMT

Hi,

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

Thanks