11 Replies Latest reply: Aug 30, 2012 7:01 AM by Wojciech Parzyszek RSS

    Excel data load, multiple tabs

      Hi All,

       

      Wonder if you could help me please as I am struggling with an excel dataload, am sure this is basic stuff but can't figure it out!

       

      When I run the three seperate loads individually they work perfectly well however when I run them together they fetch the correct row count but then hang and force me to terminate the application as it freezes every time?

       

      In this example I have commented out the third load to simplify things but surely that should also work if uncommented as they all have a common field?

       

      Note tab 1 is called Opening and tab 2 is called closing - thanks in advance.

       

      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 * FROM

      [H:\Qlikview\Recoveries\Insurance Defendant Recoveries_QlikViewDataLoad_v0.1.xlsx]

      (
      ooxml, embedded labels, table is Opening);

      LOAD * FROM

      [H:\Qlikview\Recoveries\Insurance Defendant Recoveries_QlikViewDataLoad_v0.1.xlsx]

      (
      ooxml, embedded labels, table is Closing);


      //LOAD [DWF Ref],

      //     [Date Instructions Received],

      //     [Amount of Insured Damages Recovered],

      //     [Date Closed],

      //     if([Amount of Insured Damages Recovered]>=0,1,0)

      //

      //FROM

      //[H:\Qlikview\Recoveries\Insurance Defendant Recoveries_QlikViewDataLoad_v0.2.xlsx]

      //(ooxml, embedded labels, table is Closing)