Peek Issue

[#1]

Please check the attached example Peek file

Expecting Results

Item	Newvalue	Period
Ma1	150	20092
Ma1	150	20093
Ma1	150	20094
Ma1	700	20095
Ma1	900	20096
Ma1	900	20097
Ma1	200	20098
Ma1	200	20099
Ma1	200	200910
Ma1	200	200911
Ma1	200	200912

I would like to get the value in the Final table.

Advance thanks for your help.

[#2]

hi, you don't make any relation between the tables, that's correct?

[swuehl]

Hope I got your issue correctly. Use this in the scrpt for final table:

Final:

Load * ,

if(IsNum(Ends)=0,peek(Newvalue),Ends) as Newvalue

resident A;