how to fill cell value in previous non-null row's data in loading script

[#1]

hi everyone,

i am in a problem in fill cell data in loading script.

what my data file format is blow showing, and i attached it.

when i create the loading script,

it is

but what i want to get is  when F3 column cell's value is null, fill the previous non-null value, like below

this will have to finish in qlikview, no any change in excel file.

could anyone can help me?

thank you very much.

[kaushiknsolanki]

Hi,

You can use the basic transformation available in Qlik view.

So your script will be as below.

Directory;

LOAD @1,

     @2,

     @3,

     @4,

     @5

FROM

skillset.xlsx

(ooxml, no labels, header is 1 lines, table is [Skill Set], filters(

Replace(3, top, StrCnd(null)),

Replace(1, top, StrCnd(null)),

Replace(2, top, StrCnd(null))

));

Regards,

Kaushik Solanki

[effinty2112]

Hi Tang,

               Use the file wizard transformation step to produce the code required to transform your data. The wizard is very powerful, tricky to use at first but worthwhile.

cheers

Andrew