[ASK]Hierarchy-How to fill empty fields with the latest n-level fields?

[rendiyan]

Dear QlikView,

I have generate data with hierarchy function and result like below :

As we now, with hierarchy function qlikview will generate all level that possible.

But will leave blank to the field that certain row that not use that field.

In other side, my client expectation the result will be like below :

And my question is,

is that result achieveable with QLikView load script?

if it is yes, please help me with some guide.

Many Thanks

[Anil_Babu_Samineni]

Can you try something like this?

If([Node Name2]=FindOneOf([Node Name2], '0123456789'), Previous([Node Name1]) as [Node Name2]

[rendiyan]

what does it mean?

i've tried it and nothing happen.

[Anil_Babu_Samineni]

My intention is this?

Sample:

LOAD RowNo() as ID,

     [Node Name1],

     [Node Name2],

     [Node Name3],

     [Node Name4]

FROM

Table;

Final:

NoConcatenate

LOAD ID, [Node Name1], If(FindOneOf([Node Name2], '0123456789'), [Node Name1],[Node Name2]) as [Node Name2]

Resident Sample;

DROP Table Sample;

Same Way, You can use for next 2 nodes ..

[Anil_Babu_Samineni]

Will this issue resolved? I know this is long time. But, you have to understand how Qlik community works for helpers. If it is, Please close this thread ..

[avinashelite]

try like this

if (len( trim( [Node Name2]))=0, Peek([Node Name1]),[Node Name2]) as [Node Name2]

similiar you could apply for other columns too