Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

clarkeallen
New Contributor

Fill in the blank data columns

Can someone give me some help working through this issue. I need to fill blank columns with data from previous row. I tried several approach but no luck. Any insight is appreciated.

.

Original Table:

Original Data.JPG

Desired Table

Desired Data.JPG

5 Replies
manojkulkarni
Valued Contributor II

Re: Fill in the blank data columns

This you can do while loading data. With Load Wizard , Select Enable Transformation & then use Fill option to do this operation.

MVP
MVP

Re: Fill in the blank data columns

try like:

Load
      If(Len(trim(Dim1))>0, Dim1, Peek(Dim1)) as Dim1,
      Dim2,

      Amt;

Load * Inline [
Dim1, Dim2, Amt
AA, bbb, 100
  , ccc, 200
  , ddd, 300
BB, xxx, 400
  , yyy, 500
  , zzz, 600  ]

nareshguntur
Valued Contributor

Re: Fill in the blank data columns

This might help you

Peek till not null

Cheers,

Naresh

clarkeallen
New Contributor

Re: Fill in the blank data columns

Thanks for the reply. This works Great

MVP
MVP

Re: Fill in the blank data columns

Try to mark the 'Correct Answer' the one reply which is so. That will help many(including me) in many ways.

Community Browser