Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

LOAD from multiple Excel files

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;

1 Solution

Accepted Solutions
daveamz01
Creator III
Creator III

Hi Olle,

Still cleaning the data, huh?

See the app attached.

And see documentation for "Enable transformation step"

Regards,

David

View solution in original post

6 Replies
Not applicable
Author

Not applicable
Author

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

jsaradhi
Specialist
Specialist

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.

Not applicable
Author

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 !

daveamz01
Creator III
Creator III

Hi Olle,

Still cleaning the data, huh?

See the app attached.

And see documentation for "Enable transformation step"

Regards,

David

View solution in original post

Not applicable
Author

Haha, you know it David!

Never ending cleaning story this one.

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