3 Replies Latest reply: May 4, 2016 1:36 AM by muhammad fahad RSS

    creating table from table

    muhammad fahad

      Hello Grus,

      I have the location master table in my database which is like

       

      locIDlocation
      1abc
      2xyz
      3ghi
      4stu

       

      now i have a transaction table with the field

      transaactionIDlocIDDeliveryPlaceCodeWorkingPlaceCodeamount
      123465a1245000
      123456b2236000

       

      note: the value in locId, DeliveryPlaceCode and WorkingPlaceCode are refer to location master table

      now i i fetch this table in to qlikview

       

      location:

      load

      locID,

      Location

      from location.qvd;

       

      Transaction:

      load

      Transaction Id,

      locId,

      DeliveryPlaceCode ,

      WorkingPlaceCode

      from xyz.qvd

       

      link will be created between the two table with locId and I can easily find out the locationname against each locId

      now,

      how can I find out the location name for deliverycode and workinplacecode;

       

      plz help