topic Re: Peek function in load script in Qlik Learning Discussions

Peek function in load script

Wed, 25 Feb 2015 15:37:27 GMT

Hello,

Here is a simple load :

Temp:

LOAD * INLINE [

id, field, counter

1, bla,0

2, bla,0

3, bla,0

];

Temp2:

LOAD

id,

field,

IF (peek(id)<>id,1, peek(counter) + 1) AS counter2

RESIDENT Temp

ORDER BY id;

drop table Temp;

I try to get a counter which reset for each new id find

I get only 1 for each new id, but it doesn't increment when he find 2 same id :

Any idea ?

Thanks

Re: Peek function in load script

MK_QSL — Wed, 25 Feb 2015 16:01:54 GMT

IF (peek(id)<>id,1, peek('counter2') + 1) AS counter2

IF (peek(id)<>id,1, peek(counter2) + 1) AS counter2

Re: Peek function in load script

Wed, 25 Feb 2015 16:58:40 GMT

Thank you,

I tried the solution unfortunatly it does not work hen I rename my column :

For example if I write this :

Temp2:

LOAD

id as toto,

field,

//IF (peek(id)<>id,1, peek(counter) + 1) AS counter2

IF (peek(id)<>id,1, peek('counter2') + 1) AS counter2,

peek(id) as previousvalue

RESIDENT Temp

ORDER BY id;

drop table Temp;

the result is :

because I add as toto

Thank you for your help

Re: Peek function in load script

MK_QSL — Wed, 25 Feb 2015 17:03:31 GMT

Temp:

LOAD * INLINE [

id, field, counter

1, bla,0

2, bla,0

3, bla,0

];

Temp2:

LOAD

id,

field,

IF (Previous(id)<>id,1, peek(counter2) + 1) AS counter2

RESIDENT Temp

ORDER BY id;

drop table Temp;

Re: Peek function in load script

MK_QSL — Wed, 25 Feb 2015 17:06:30 GMT

one more easier way

Temp:

LOAD

AutoNumber(RecNo(),id) as counter22

INLINE [

id, field, counter

1, bla,0

2, bla,0

3, bla,0

];