Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Load multiple files from multiple paths

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

0 Replies