Partial Reload, new files evey day

Wed, 30 Jul 2014 10:56:39 GMT

Hi,

Every day I'm receiving a new excel file containing yesterdays transactions. Now that the files are piling up, a regular reload is staring to get pretty time consuming. I've been looking at quite a lot of tutorials but I'm still pretty much clueless of how to solve my particular case. Any ideas?

Thanks in advance,

Olle

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';
SET TimeFormat='hh:mm';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

//INCOMING

ColumnHeader:

LOAD
     Reference,
     Type,
     SettlementAmount,
     Time15,
     Time30
FROM
[DataLog\*.xls]
(ooxml, embedded labels, table is Incoming);

//OUTGOING

Directory;
Add LOAD
     Reference,
     Type,
     SettlementAmount,
     Time15,
     Time30
FROM
[DataLog\*.xls]
(ooxml, embedded labels, table is Outgoing);

topic Partial Reload, new files evey day in QlikView

Partial Reload, new files evey day