topic Re: Adding unique row number in QlikView

Adding unique row number

rsdhavle — Thu, 19 Dec 2013 07:35:49 GMT

I have one column in which i am arranging data in a descending order. I want to give a unique row number for each row like 1,2,3,4...

but suppose the data is same in two rows lets say value is 30 and again 30 in the second row it should give same number to both the rows like 1,1 or 2,2

What would be the best function to use and what would be the expression. Is it Rank function that should be userd?

Re: Adding unique row number

Gysbert_Wassenaar — Thu, 19 Dec 2013 07:54:55 GMT

You could add a counter field in the script and use that:

Load MyField, autonumber(MyField) as Counter

From ...

You could also try using the fieldindex function as an expression: fieldindex('MyField', MyField)

Re: Adding unique row number

Anonymous — Thu, 19 Dec 2013 08:17:46 GMT

Please refer to the attached file ,

This resolves your question.

s_no in the sample is your output field.

Regards

Nitin

Re: Adding unique row number

jagan — Thu, 19 Dec 2013 08:48:38 GMT

Hi Rohan,

Use RowNo() in load script this will give 1,2,3,4,5 etc.

Example:

Data:

LOAD

RowNo() AS UniqueNumber

FROM DataSource;

Regards,

Jagan.

Re: Adding unique row number

Fri, 20 Dec 2013 10:07:08 GMT

If the values are not in sorted order then what will be the procedure.

Re: Adding unique row number

Sat, 21 Dec 2013 04:27:56 GMT

Hi rohan,

Dev03:

LOAD * Inline

[

Fild,Value

A,1

B,2

C,3

D,3

E,4

F,5

G,5

H,6

I,7

J,7

K,8

];

LOAD RowNo() AS UID,* Resident Dev03;