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
(ooxml, embedded labels, table is Opening);
LOAD * FROM
(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
//
//(ooxml, embedded labels, table is Closing)
