Replacing missing values with previous row's value

[#1]

Hi there,

I have an excel table such as the following:

Product	Price
Product A	10
-	10
Product B	20
-	20

Notice that some of the values for 'Product' is missing. What I would like to do in my load statement, is to populate these missing values with the value of the above row (i.e in this case replace first '-' with Product 'A', and second '-' with 'Product B')

Is there a way in the Load statement to check if Product is null/missing, then populate with the value above?

[jonathandienst · Accepted solution]

Hi

Like this:

LOAD

     If(IsNull(Product), Peek('Product'), Product) As Product,

     Price

FROM ...

Or use the advanced filtering from the load wizard and use the Fill option.

HTH

Jonathan

[Anonymous]

Hi

Looks like youare in need of the Peek() function.

This blog post gives lots of details:

          Generating Missing Data In QlikView

Best Regards,     Bill

[#4]

Thanks!

[#5]

Thanks!