Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following data
hierarchy_id,node_id,parebt_node_id,name,node_level
=====================================
23 1418422 1418180 ASIA 1
23 1418192 1418422 ARMENIA 2
23 1418198 1418422 BAHRAIN 2
23 1418206 1418422 BHUTAN 2
I want to create hierarchy on continent + country
if any one click asia list of country will open.
I have written the following codes:
hierarchy:
LOAD "HIERARCHY_ID" as Id,
"NODE_ID" as NodeID,
"PARENT_NODE_ID" as ParentID,
NAME as NodeName,
"NODE_LEVEL" as NodeLevel;
SQL SELECT *
FROM "HIERARCHY";
//STORE hierarchy into E:\Extraction\Qvd\hierarchy.QVD;
//Drop table hierarchy;
continent_hierarchy_check:
Hierarchy(NodeID, ParentID, NodeName)
LOAD NodeID, ParentID, NodeName
Resident hierarchy
;
DROP TABLE continent_hierarchy_check;
how will i check my data as well
thank you i have done---
Hierarchy(NodeID, ParentID, NodeName,,NodeName,TreeView)
LOAD
NodeID, ParentID, NodeName
Resident hierarchy
;
thank you i have done---
Hierarchy(NodeID, ParentID, NodeName,,NodeName,TreeView)
LOAD
NodeID, ParentID, NodeName
Resident hierarchy
;