4 Replies Latest reply: Jul 10, 2014 6:08 AM by Satyadev Jaiswal RSS

    Problem Seeing Full Data

      Hi.

       

      I have an excel table loaded with this data

       

      YearMonthCar         Expense

      201411                    100

      201421                    100

      201431                    100

       

      Sql 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,

      but how do i fix it?