Peek() function not working

hjm35055 — Sat, 16 Nov 2024 18:04:41 GMT

I am having an issue with the Peek() function. Below is my script. Peek is working fine if I use it on StateID_Year but I cannot get it to work on State_Pop or in my IF statement. I have also tried replacing the "If(IsNull(State_Pop)...." with "If(Len(State_Pop) = 0"

Population:
NoConcatenate
Load
StateID_Year,
Peek(StateID_Year) as PeekStateID_Year,
Peek(State_Pop) as PeekState_Pop,
If(IsNull(State_Pop), Peek(State_Pop), State_Pop) as State_Population
Resident caCase
Order By
StateID_Year asc
;

Thanks in advance for any help!

Re: Peek() function not working

Shiva123 — Wed, 23 Sep 2020 01:24:02 GMT

Can you try like this

Load
StateID_Year,

State_Pop,
Peek(StateID_Year) as PeekStateID_Year,
Peek(State_Pop) as PeekState_Pop,
If(IsNull(State_Pop), Peek(State_Pop), State_Pop) as State_Population
Resident caCase
Order By
StateID_Year asc

topic Peek() function not working in App Development

Peek() function not working

Re: Peek() function not working