topic link the hierarchy with table in QlikView

link the hierarchy with table

beck_bakytbek — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

i got a question:

i have a follwing hierarchy:

Hierarchy(NodeID1, ParentID1, NodeName1, ParentName1, NodeName1, PathName1, '\', Depth1) LOAD * inline [

NodeID1, ParentID1, NodeName1

1, 4, London

2, 3, Munich

3, 5, Germany

4, 5, UK

5, , Europe

];

and following

table:

Turnover:

load * Inline [

Country, Turnover

UK, 120

Germany, 150

];

my question: what is the best way to join my hierarchie with the table: turnover, should i rename my field in the table: Turnover?

does have anybody idea?

thanks a lot

beck

Re: link the hierarchy with table

aapurva09 — Wed, 22 Mar 2017 09:09:39 GMT

Hi,

You need to connect the Turnover table to the hierarchy table by using NodeName1 column, as this will have all the country names.

Thanks

Re: link the hierarchy with table

beck_bakytbek — Wed, 22 Mar 2017 09:12:28 GMT

Hi Apurva,

you mean this way of proceeding?

table:

Turnover:

load * Inline [

Country, Turnover

UK, 120

Germany, 150

];

load

Country as NodeName1,

Turnover

resident

Turnover;

drop table Turnover;

Re: link the hierarchy with table

aapurva09 — Wed, 22 Mar 2017 09:20:39 GMT

Yeah, now connect your hierarchy table with this new table with NodeName1 key.