topic Function peek does not work with a LOAD statement in QlikView

Function peek does not work with a LOAD statement

Tue, 16 Nov 2010 16:24:34 GMT

Hello,

I have a problem with peek function when using a load statement:

Let's say there is a table called 'ListTickets', with one field 'Ticket', and only three values : A, B, and C

I would like to use the peek function with each row one at a time, save the value in a variable, and use the variable in a load statement

My code is:



ListTickets:

LOAD * INLINE [

Ticket

A

B

C

];

for a=0 to 2

let teest = chr(39) & peek('Ticket', $(a), ListTickets) & chr(39);

TableX:

load $(teest) as TicketTest

AutoGenerate(1);

next

Unfortunately, I do not understand the behaviour of the script

On the first loop (when a=0), 'teest' gets the value A (as expected), and the load statement works great.
On the second and third loop (when a=1 or a=2), 'teest' gets the value NULL (I expect values B and C)

If I write :

let teest = peek('Ticket',0, ListeTickets);
let teest = peek('Ticket',1, ListeTickets);
let teest = peek('Ticket',2, ListeTickets);

before any LOAD statement, I have no problem, teest has the expected values (A, B, and C) [:)]

after the LOAD statement, teest has always NULL as value [:@]

Do you know what happens ?

Function peek does not work with a LOAD statement

Miguel_Angel_Baeyens — Tue, 16 Nov 2010 16:39:40 GMT

Hello Pierre,

I've done a few changes to your script, and it works fine for me

ListTickets:LOAD * INLINE [TicketABC]; FOR a = 0 TO 2 LET teest = PEEK('Ticket', $(a), 'ListTickets'); // Fields are case sensitive, both field and table name must be quoted TableX: LOAD '$(teest)' as TicketTest // I use single quotes here, instead of using them as chr(39) in the variable above AUTOGENERATE (1); NEXT

Hope this helps

Function peek does not work with a LOAD statement

Tue, 16 Nov 2010 16:59:52 GMT

Hi Miguel

Thanks a lot for your help !

It seems the problem is coming from the quotes that I forgot when specifying the table name in the peek function.

In QV help, it is explained that the table name should not be between quotes, and clearly it works with quotes...

Thanks again

Function peek does not work with a LOAD statement

Tue, 16 Nov 2010 17:06:36 GMT

Hi Pierre (Miguel),

this is absolutly correct. In the help it looks quite the other way as it is in reality. Don't bother, this is a trap I felt in about 10...... times 😉

Regards, Roland