Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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