Excel multi load

[#1]

Hi,

I am loding data from excel month wise and i have month wise excel file with same column on that.

Qualify *;

Table1:

load

Field1,

Field2,

Field3

...

Field7

From January.xls

load

Field1,

Field2,

Field3

...

Field7

From February.xls

upto december and i want to create a single table from this 12 excel file but when i load then 12 single file is created.

Thanks

[#2]

Hi,

You are great, But Qualify *; syntax is put in the above of all this load because i load this table independently reason there is another single table with same fields but i dont want to connect with this table. If i remove Qualify synthetic key table is created please help for this.

Thanks

[Anonymous]

Then just rename the fields. Example below with a few fields renamed:

FOR Each File in filelist ('*.xls')

LOAD

'$(File)' as Name,

[Txn Date] as TransactionDate,

     [Value Date] as NewValueDate,

     Description as SomeOtherDescription,

     [Ref No.],

     Debit,

     Credit,

     Balance

FROM

[$(File)]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

NEXT File