LOAD from multiple Excel files

[#1]

Hi,

need to load the below from multiple Excel files.

Some sort of FOR EACH File scripting, but cannot seem to get it right.

Any suggestions?

Kind Regards,

Olle

Tbl:

LOAD currency,

     [account no.],

     CTPY,

     [value date],

     [CR/DR],

     amount,

     status,

     reference,

     type,

     ProcessDate,

     ProcessTime,

     1 As Key

FROM

[sampleDateTime.xls]

(biff, embedded labels, header is 2 lines, table is dateTime$);

Join(Tbl)

LOAD Date(@1) As Date,

     Time(@2) As Time,

     1 As Key

FROM

[sampleDateTime.xls]

(biff, no labels, header is 1 lines, table is dateTime$) Where RecNo() < 2;

[#2]

see this

http://community.qlik.com/thread/105143

[#3]

Thanks, tried to apply this example earlier today but Im too much of a noob im afraid

Did not manage to make it work properly

[Anonymous]

try the attached file. there are two variables that need to be set to your folder paths - one for the path with xls files and the other with path to where the qvd files need to be saved...good luck.

[#5]

Looks great! Thanks a lot!

Can you pls have a look at the attached though. Seem to be missing out on something when trying to apply your code. Something with the paths maybe? Or is it the folder structure?

Thanks in advance,

Olle !

[daveamz · Accepted solution]

Hi Olle,

Still cleaning the data, huh?

See the app attached.

And see documentation for "Enable transformation step"

Regards,

David

[#7]

Haha, you know it David!

Never ending cleaning story this one.

But your help is useful as always, thanks a lot!!