topic Re: Re: LOAD from multiple Excel files in QlikView

LOAD from multiple Excel files

Mon, 01 Dec 2014 15:30:33 GMT

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;

Re: LOAD from multiple Excel files

Mon, 01 Dec 2014 15:34:52 GMT

see this

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

Re: LOAD from multiple Excel files

Mon, 01 Dec 2014 15:43:16 GMT

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

Re: Re: LOAD from multiple Excel files

Anonymous — Mon, 01 Dec 2014 16:33:23 GMT

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.

Re: Re: Re: LOAD from multiple Excel files

Tue, 02 Dec 2014 10:24:21 GMT

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 !

Re: Re: Re: Re: LOAD from multiple Excel files

daveamz — Tue, 02 Dec 2014 13:20:37 GMT

Hi Olle,

Still cleaning the data, huh?

See the app attached.

And see documentation for "Enable transformation step"

Regards,

David

Re: Re: Re: Re: LOAD from multiple Excel files

Tue, 02 Dec 2014 14:22:58 GMT

Haha, you know it David!

Never ending cleaning story this one.

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