Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gshockxcc
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