topic Re: Quick Question to Peek() about referencing to input Table in QlikView

Quick Question to Peek() about referencing to input Table

Nocto — Wed, 25 Nov 2020 16:16:04 GMT

Hey guys,

so why doesnt this Work:

Sales:
LOAD * INLINE [
Sales
100
200
300
400
];

Sales2:

load

peek(Sales, 'Sales') as S1

resident Sales;

I assumed with that I would get

S1
-
200
300
400

as output.

But

When I do this: peek(Sales,-1, 'Sales') as S1 it works but only get the last Entry.

so what do i not understand in this syntax?

rubenmarin — Sun, 01 Nov 2020 11:22:59 GMT

Hi, you can use (adding 2nd parameter to specify row to retrieve)

Sales2: load peek(Sales,RowNo(),'Sales') as S1 resident Sales;

But I don't know what are you trying to do this way, so maybe it's not what you need.

MayilVahanan — Sun, 01 Nov 2020 14:37:14 GMT

Simply, you can use like below

Sales:
LOAD *, Peek(Sales) as PeekSales INLINE [
Sales
100
200
300
400
];

FYIP: Peek starts with 0 for 1st row, 1 for 2nd row and so on..