Peek

[#1]

Hi Friends,

   I have a small doubt in peek function. Please find the attached Excel & QVW. As per the attached excel I want to show the output in QVW. I can reach the output through If condition. But I want without if condition. please help me.

[lironbaram]

hi have a look at the attach example

this is the script

DataTemp:

LOAD Name,

     ID

FROM

[peek test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Data:

load *,

  if(previous(Name)=Name,Peek(ID),0) as peekid

Resident DataTemp

Order by Name, ID;

drop Table DataTemp;

[alexandros17]

Simply do:

LOAD Name,

     ID,

     Peek_ID

FROM

(ooxml, embedded labels, table is Sheet1);

There is no need of peek function ...