topic Create an unique key for duplicate Values in QlikView

Create an unique key for duplicate Values

Tue, 13 Aug 2013 11:28:24 GMT

Hi,

I trying to create unique number for repeting vaules in script level

Value	Trying to create Key
1	1
1	2
1	3
1	4
2	1
2	3
2	4
3	1
3	2

Can any one help

regards

Mahesh

Re: Create an unique key for duplicate Values

rbecher — Tue, 13 Aug 2013 11:47:51 GMT

Hi Mahesh,

this works:

Data:

LOAD * INLINE [

Value

];

Result:

NOCONCATENATE LOAD Value, if(IsNull(Previous(Value)) or Value>Previous(Value), 1, Peek(Key)+1) as Key

Resident Data;

- Ralf

Re: Create an unique key for duplicate Values

Gysbert_Wassenaar — Tue, 13 Aug 2013 12:28:51 GMT

Try:

Data:

LOAD *, if(Value=previous(Value), peek(Key)+1,1) as Key INLINE [

Value

];

Re: Create an unique key for duplicate Values

swuehl — Tue, 13 Aug 2013 12:46:10 GMT

Another option:

Data:

LOAD *, autonumber(recno(),Value) as Key INLINE [

Value

];

Re: Create an unique key for duplicate Values

er_mohit — Tue, 13 Aug 2013 12:47:51 GMT

Try this

Data:

LOAD * INLINE [

Value

];

NewData:

LOAD Value,

if(Previous(Value)<>Value,1,RangeSum(1,Peek(Key))) as Key

Resident Data

Order by Value;

DROP Table Data;

output like this

Value	Key
1	1
1	2
1	3
1	4
2	1
2	2
2	3
3	1
3	2

See the attached file

Re: Create an unique key for duplicate Values

rbecher — Tue, 13 Aug 2013 12:51:16 GMT

Interesting solution! But, this could be expensive for QV to handle a large amount of counters..

- Ralf