topic Recursive table in QlikView

Recursive table

thierrytt1102 — Tue, 16 Dec 2014 10:17:24 GMT

Hi,

I've got a question concerning a straight table:

I have a table like:

Name ParentName NameStatus.

John Charles Alive

Charles Andrew Dead

And I'd like to have a straight table like this:

Name NameStatut ParentName ParentStatus.

John Alive Charles Dead

I've tried set analysis like P(ParentName), lookup/peek doesn't exist in charts and only(TOTAL Status) but No Way!

Due to the amount of data, I need to keep one this information into one table in my datamodel.

Thank you!

anbu1984 — Tue, 16 Dec 2014 10:30:55 GMT

Temp:

Load * Inline [

Name,ParentName,NameStatus

John, Charles,Alive

Charles,Andrew,Dead ];

Left Join(Temp)

Load Name as ParentName,NameStatus As ParentStatus Resident Temp;

thierrytt1102 — Tue, 16 Dec 2014 11:21:56 GMT

Thanks

That's way my first attempt. It's working but It's like to avoid a resident load as this table is huge.

Is there a way to do it within the chart?

Thx

anbu1984 — Tue, 16 Dec 2014 11:58:52 GMT

=TextBetween(Concat(TOTAL Name &'|' & NameStatus,','),ParentName & '|',',')

thierrytt1102 — Tue, 16 Dec 2014 12:07:47 GMT

I don't know if this is the best practice but it works perfectly in my case.

Thank you very much

Tue, 16 Dec 2014 12:32:44 GMT

I found this a very easy way to deal with this problem (still using resident):

Load Name as ParentName, NameStatus as ParentStatus resident Table;

This will load again your table, but now associating ParentStatus with ParentName. The association with the other table is automatically stablished.

thierrytt1102 — Tue, 16 Dec 2014 13:49:31 GMT

Yes I see.

I asked it to remain as a single table because this is actually a linktable.

Cheers