Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi, you don't make any relation between the tables, that's correct?
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;