3 Replies Latest reply: Jul 11, 2014 3:15 PM by Anand Chouhan RSS

    Data Missing

      Hi.

       

      I have an excel table loaded with this data (and more tables such as it)

       

      YearMonthCar         Expense

      201411                    100

      201421                    100

      201431                    100

       

      Sql table (Primary Table) with this data

       

      YearMonthCar     Income

      201411               100

      201431               300

       

      The common key- is YearMonthCar

       

      when i load the data in qlikview table the data from second row from excel table is missing.

       

      I understand why (because of the join) how do i get to present it,

      even if i will need to create virtual lines in the primary table?

        • Re: Data Missing
          Massimo Grossi

          t:

          load * from excel;

          join (t) load * from sqlserver;

           

           

           

          t:

          load * inline [

          YearMonthCar   ,      Expense

          201411         ,           100

          201421         ,           100

          201431         ,           100

          ];

           

          join (t) load * inline [

          YearMonthCar ,    Income

          201411       ,        100

          201431       ,        300

          ];

          • Re: Data Missing
            Anand Chouhan

            Every time we have try joining with the master table see the example below for that

             

            Example:-

             

            ExcelTable:

            Load * Inline

            [YearMonthCar,         Expense

            201411,                    100

            201421,                    100

            201431,                    100

            ];

             

            Left Join(ExcelTable) // Or Join(ExcelTable) if the Excel table is master table then try with Left join

             

            Sqltable:

            Load * Inline

            [ YearMonthCar,    Income

            201411,               100

            201431,               300

            ];

             

            Note:- You get the problem due join.

            • Re: Data Missing
              Anand Chouhan

              Hi Gil Lion

               

              If you got solution from the thread then mark correct or helpful and close the thread.

               

              Regards,

              Anand