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

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

Wed, 25 Nov 2020 16:16:04 GMT

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.

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

kaushiknsolanki — Mon, 17 Jul 2017 08:09:31 GMT

Hi,

You can use the basic transformation available in Qlik view.

So your script will be as below.

Directory;

LOAD @1,

@2,

@3,

@4,

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

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

effinty2112 — Mon, 17 Jul 2017 09:47:33 GMT

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