6 Replies Latest reply: Jul 20, 2017 3:58 AM by uri ophir RSS

    Combine content of two tables

    pooja goswami

      How do we  use the content of two table in order to make the dashboard.

        • Re: Combine content of two tables
          Shun Wong

          Hi Pooja,

           

          All you have to do is use Qliks associative modelling to do this. Easiest way is to find a common field within both your sources, and ensure both the Linking field are the same name in both tables. This will create a link between the two tables, and then in the front end you can just add your dimension and measures.

          • Re: Combine content of two tables
            Tomasz Truszkowski

            Can you give us a sample of both tables?

            Tomasz

            • Re: Combine content of two tables
              sravan Vennu

              Hello..

               

              FYI,

               

              - If you have tables with same structure Qlikview will concatinate tables automatically.

                 

              T1:T2:
              NumSalNumSal
              110041000
              220052000
              330063000

               

              Script:

              T1:

              Load * from XXX;

              T2:

              Load * from YYY;

                 

              Result:
              T1:
              NumSale
              1100
              2200
              3300
              41000
              52000
              63000

               

              - If you have tables with diffrent structure you have to do a force concatenate tables.

                 

              T1:T2:
              NumSalNumExp
              110041000
              220052000
              330063000

               

              Script:

              T1:

              Load * from XXX;

              Concatenate

              T2:

              Load * from YYY;

               

              Result:
              T1:
              NumSaleExp
              1100
              2200
              3300
              4 1000
              5 2000
              6 3000

               

              Note: When you Concatenate/Generate a relation, the common Field/Primary Key will be only one field(i.e. In the above example Num, from 2 tables, it is concatenated as one single field) .

              • Re: Combine content of two tables
                Krishna KS

                Hi pooja,

                 

                Can you explain the data structure for the 2 tables you are trying to use together. If they are of same structure then we can concatenate. If not need to view the data structure.