Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

link the hierarchy with table

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

3 Replies
aapurva09
Creator
Creator

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

beck_bakytbek
Master
Master
Author

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;

aapurva09
Creator
Creator

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