1 Reply Latest reply: Sep 23, 2012 12:58 AM by anutosh_dhar anutosh_dhar RSS

    hierarchy continent country

    anutosh_dhar anutosh_dhar

      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