Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
can u show me how...
the row table like attached above.
i am a newbee
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