Load multiple files from multiple paths

gshockxcc — Thu, 29 Jan 2015 13:54:21 GMT

I found a similar post to answer some of my questions, but there are differences in my application that complicate this procedure.

I am referencing this post: http://community.qlik.com/message/440398#440398

For each of the CSV files I have, the tab is the same as the file name. If you look at the sample file provided, wherever 'Sheet1' is used, I need to change that to the 'filename' for each file.

Should I try to modify the existing script using

{

Filee=peek( 'filename', i, 'master' );

}

Or should I try to use something like this?

{

Load *, filename( ) as X from

C:\UserFiles\abc.txt

}

Wondering if this statement will work:

{

master:

LOAD filename,

folder

FROM

address.xlsx

(ooxml, embedded labels, table is X);

}

Thanks in advance

topic Load multiple files from multiple paths in QlikView

Load multiple files from multiple paths