2 Replies Latest reply: Mar 1, 2013 3:55 AM by Henric Cronström RSS

    Qlikview not importing all records from excel

    Mohamed Eshack

      I am trying to import into excel all records from excel file;  How I can import all records into qlikview; please advise;

       

      SET ThousandSep=',';

      SET DecimalSep='.';

      SET MoneyThousandSep=',';

      SET MoneyDecimalSep='.';

      SET MoneyFormat='£#,##0.00;-£#,##0.00';

      SET TimeFormat='hh:mm:ss';

      SET DateFormat='DD/MM/YYYY';

      SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

      SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

      SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

      LOAD Account,

                Date,

                Credit

      FROM [C:\Users\ESHACK\Desktop\The Western Matriculatin School\Academic Year 2012-2013\QV_TRANSACTIONS_Monthly.xls] (biff, embedded labels, table is [Transaction Detail by Account$]);

       

       

       

       

       

      The result is as follows:

      Books2000.0017/05/2012
      Books2750.0031/05/2012
      Books2800.0024/05/2012
      Books2800.0025/05/2012
      Books2800.0031/05/2012
      Books2850.0023/05/2012
      Books2850.0029/05/2012
      Books2850.0030/05/2012
      Books2850.0031/05/2012
      Books2950.0028/05/2012
      Books2950.0030/05/2012
      Books2950.0031/05/2012
      Books3000.0023/05/2012
      Books3000.0025/05/2012
      Books3050.0031/05/2012
      Books3800.0030/05/2012
      Books3870.0025/05/2012

      Please find attached excel file;

       

      qlikview version 8.5 excel file: office 2010