2 Replies Latest reply: Feb 16, 2012 4:50 AM by SEA_1970 RSS

    Join issue

      Hi,

      As a newbie on QlikView I've got in to a challange on joins (I think...). In this case I have two qvd-tables, Company and CompanyInformation. Unfortunately CompanyInformation.qvd conatins more records than I have active companies in the Company.qvd. In my Chart (Pivot Table/Straight Table) I want to show information on records that is present in both tables only.

       

      This is a short example of my case:

       

      Company.qvd contains

      NamePhoneCreatedDateClosedDatefk_CompanyInformationId
      A555-103-00019.01.20071
      B555-103-00125.08.20032
      C555-103-00230.01.20014
      D555-103-00316.05.20075


      CompanyInformation.qvd contains

      CompanyInformationIdGLNContactName
      17080000000100Torgersen
      27080000000120Rahmanian
      3

      7080000000125

      Evje
      47080000000178Jansson
      57080000000183Olsen
      67080000000210Myrhaug
      77080000000325Brunner


      And this is what I want to show in my Chart (Pivot Table/Straight Table):

      CompanyInformationIdGLNCompanyName
      17080000000100A
      27080000000120B
      47080000000178C
      57080000000183D


      Any suggestions?

        • Re: Join issue
          Celambarasan Adhimulam

          Hi,

               Company:

               Load

                          Name as CompanyName,

                         fk_CompanyInformationId as CompanyInformationId,

               From

                    Company.qvd;

          Left Join(Company)

               Load

                         CompanyInformationId,

                         GLN

               From

                    CompanyInformation.qvd;

           

          QV automatically joins the table based on the common field name

           

          Hope it helps

           

          CELAMBARASAN