Fill in the blank data columns

[Anonymous]

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:

Desired Table

[manojkulkarni]

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

[tresesco]

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]

This might help you

Peek till not null

Cheers,

Naresh

[Anonymous]

Thanks for the reply. This works Great

[tresesco]

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