topic Re: Recursive store in QlikView

Recursive store

Wed, 05 Mar 2014 12:30:42 GMT

Hi,

i have an input table like this:

I need to create a table like this:

Which is the best way to achive the goal'

Many thanks!

Wed, 05 Mar 2014 12:52:10 GMT

in your script, write this

LOAD

subfield(Key2,';') as Key2

Resident

Wed, 05 Mar 2014 13:12:27 GMT

Hi Romeo,

this script should work as aspected:

RawData:

LOAD * Inline [

Key1, Key2

A,1

B,2;3;4

C,4;5;6

];

Result:

LOAD

Key1 AS Res1,

SubField(Key2, ';', IterNo()) AS Res2,

RowNo() AS ResKey

Resident RawData

While SubStringCount(Key2,';') >= IterNo()-1

;

DROP Table RawData;

HtH

Roland