0 Replies Latest reply: Jun 20, 2013 4:44 PM by Dinesh Thoniparambil RSS

    Hierarchy Load

      I have below raw data.

       

      EntityParentValue
      USA
      150
      ConnecticutUSA30
      DanburyConnecticut10
      SouthburyConnecticut20
      TexasUSA90
      HoustonTexas40
      DallasTexas50
      AlabamaUSA30

       

      How can I get a table in QlikView from above raw data to look like below (lowest level entity)

       

      EntityValue
      Danbury10
      Southbury20
      Houston40
      Dallas50
      Alabama30

       

      Thanks,

      Dinesh.