topic Re: autonumber rows in QlikView

autonumber rows

wunderch — Tue, 20 Feb 2018 14:35:27 GMT

Hi guys,

I have a table like this:

ID	Value
1	50
1	USA
1	Mark
2	33
2	Germany
2	Chris

Now I need a table like this:

ID	Value	Key
1	50	1
1	USA	2
1	Mark	3
2	33	1
2	Germany	2
2	Chris	3

How can I do this in script??

Thanks for your answers!

Regards

Chris

Re: autonumber rows

sunny_talwar — Tue, 20 Feb 2018 14:36:17 GMT

May be this

LOAD ID,

Value,

AutoNumber(RowNo(), ID) as Key

FROM ...;

Re: autonumber rows

wunderch — Tue, 20 Feb 2018 14:43:49 GMT

Thanks for your quick answer!

Re: autonumber rows

YoussefBelloum — Tue, 20 Feb 2018 14:47:21 GMT

Hi sunny,

autonumber is not supposed to create unique integer value for each distinct evaluated value ?

here on every line there is new rowno() number.

can you explain how it works please ?

Re: autonumber rows

sunny_talwar — Tue, 20 Feb 2018 14:49:04 GMT

I am not just using RowNo(), but AutoNumber on top of RowNo() which will restart counting based on different IDs. Does that make sense?

Re: autonumber rows

YoussefBelloum — Tue, 20 Feb 2018 14:54:42 GMT

Yes of course I read carefully what you suggested. I talk about rowno() only because rowno() is different on every line. and referering to the syntax, Autonumber created a unique integer for every value etc...

can't understand why it is restarting the counting using Rowno() and ID.. as long as every values evaluated on every line is unique.

Autonumber(1,1)

Autonumber(2,1)

Autonumber(3,1)

Autonumber(4,2)

Autonumber(5,2)

Autonumber(6,2)

Re: autonumber rows

sunny_talwar — Tue, 20 Feb 2018 14:58:47 GMT

Do you understand the use of the second parameter within the AutoNumber function, right? As long as the second parameter is the same in the AutoNumber it will create a continuous number, but once changed it restart the counting from 1. Autonumber will work like this....

Autonumber(1,1) = 1

Autonumber(2,1) = 2

Autonumber(3,1) = 3

Autonumber(4,2) = 1

Autonumber(5,2) = 2

Autonumber(6,2) = 3

Re: autonumber rows

YoussefBelloum — Tue, 20 Feb 2018 15:07:25 GMT

Thank you

No, I didn't know about it.. for this one I only read the help and i didn't notice the AutoID part (which is the second parameter you're talking about).