Peek and Previous

[HMUTUAL01]

I am trying to create a dataset which looks back and populate the previous days balance but it doesn't seem to be populating the previous fields. Below is my query.

[JonnyPoole]

try previous() instead of peek() to grab the prior value

[HMUTUAL01]

I adjust the editor to the following but still not retrieving any data

[JonnyPoole]

Try exiting the script before the LEFT join and reloading to see if the previous() function is actually working. That will tell us if there is an issue with PREVIOUS or if its the LEFT JOIN that is causing the unexpected values.

[HMUTUAL01]

I'm new, what do you mean by reloading? This is what I have so far.

[JonnyPoole]

What I mean by 'Reload' is to click the 'Load' Button in the top right so as to reload the data in the app and process the proposed script changes.

[HMUTUAL01]

Now I am getting an error but all I did was add  "Exit Script"

[JonnyPoole]

ahhh... that could be a clue: the fact that its complaining about the field fund_plan_key.

Is that field definitely in the table you are performing a resident load from? Try commenting out the lines with previous() to ensure it loads correctly (and exits). Either the error is because of a missing field or mispelt field or its a logic issue of some kind. We're close!  

[HMUTUAL01]

It ran  but this time created some synthetic keys. I'm going to change the fund_plan_key to the field I am trying to match against. 

[HMUTUAL01]

DS_PLAN_FUND_KEY=Previous(DS_Fund_Plan_Key) also gave me the same unfound error message