Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;
Yeah, now connect your hierarchy table with this new table with NodeName1 key.