Peek() function not working

[hjm35055]

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!

[Shiva123 · Accepted solution]

HI

 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