FILLING BLANK CELL

[#1]

Hi,

i have raw data table, but not all the cell filled

if i want to load the table in qlikview but the cell being filled with the data abve the column.

sample raw table & result expected attached (2 sheet)

what should i do?

Thanks

Steven

[alexandros17]

There is no attach but try this:

if the field you want to be filled with the previous value is myField then:

Load

...

if(isnull(myField) or trim(myField)='', previous(myField), myField)

...

resident myTable

[#3]

oops,

i have tried your solution above...

the result only fill the first blank row wtih the previous value.

when going to the next blank row, it still remain blank because the previous one is null also.

my data have more than one blank row... all the blank row should be filled with the last filled

Thanks

Steven

[alexandros17 · Accepted solution]

You're right .... so you should try a loop where you take the value with peek function and if next record has non value you use the stored value

[#5]

can u show me how...

the row table like attached above.

i am a newbee

[#6]

Dear Alessandro,

LOAD IF(ISNULL(Product) OR TRIM(Product)='', Peek(Product1), Product) as Product1,

           Date,

           Transaction

From

[H:\....

and the result is right.. is the script above true?

Thanks

Steven