Discussion Board for collaboration on QlikView Scripting.
I have a table like this:
And I would like to convert / expand it to this:
Any help would be highly appreciated!
Thanks in advance.
Go to Solution.
Hi, you can try this in the script -
load * Inline [
load _Row, Formula as _F
_Row as _F, Formula
drop table tab;
load _Row as Row,
if(isnull(Formula), _F, Formula) as Formula
drop table Tmp;
Thanks a lot Patrick!