How to fix problems with Peek in the script?

[#1]

Hi, I'm trying to use the peek function in the script. Basically I have one value in the first month and I want to populate this down.

The issue peek function is having some aleatory issue and I cannot have this visible down.

The expression is the following =

if(isnull(DataPrice),  Peek (DataPrice), DataPrice) as PricePeek,

ordered by Date

Please see below the expected results:

The files with the script are enclosed.

Thanks in advance, Leadro

[giakoum]

try

if(isnull(DataPrice),  Peek (PricePeek), DataPrice) as PricePeek,

[DavidFoster1]

Peek does not work that way. You might look at Previous.

My suggestion is that what you do is:

1. Read the month start records from the file into a mapping table.
2. Load the full table using APPLYMAP to return the matching monthstart values.

[#4 · Accepted solution]

As suggested by Ioannis.

[m_woolf]

peek expects the field name  to be a string.

Try:

peek('DataPrice')

Also peek will return null on the first record.

[DavidFoster1]

Isn't the price wrong for Supplier A?

[#7]

For supplier A per logic 2000 gets applied where ever there is a null. not sure what the desired output should be though.