Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

gshockxcc
Contributor

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

Tags (3)