1 Reply Latest reply: Nov 1, 2014 2:35 AM by anbu cheliyan RSS

    How to define two joins between 2 tables?

      Hi All,

       

      How to define two joins between 2 tables?

       

      Scenario:

       

      We have two tables, 1 is Product details, 2nd is Conversation rate. so we need to define 2 joins between these 2 tables those are

      like

      Product.Date=Conversation.Date  and

      Product.Country=Conversation.Country

       

       

       

      Thanks & Regards

      Kumar

        • Re: How to define two joins between 2 tables?
          anbu cheliyan

          In Qlikview, you cannot explicitly mention join keys as in Sql. Instead if you have same field names, automatically tables are joined through them. If your join field names are not same, then rename fields in Load.

           

          If you write Load like this, then both the tables are automatically joined through REST and DATE.

          Table1:

          LOAD USA,

               REST,

               DATE,

               CR

          FROM

          [Book1.xlsx]

          (ooxml, embedded labels, table is Sheet1);

           

          Table2:

          LOAD PRODUCT,

               REST,

               DATE,

               SALE,

               E

          FROM

          [Book1.xlsx]

          (ooxml, embedded labels, table is Sheet2);

           

          If you explicitly mention keyword join, then both tables will be merged into one table

          Table1:

          LOAD USA,

               REST,

               DATE,

               CR

          FROM

          [Book1.xlsx]

          (ooxml, embedded labels, table is Sheet1);

           

          Join(Table1)

          LOAD PRODUCT,

               REST,

               DATE,

               SALE,

               E

          FROM

          [Book1.xlsx]

          (ooxml, embedded labels, table is Sheet2);