0 Replies Latest reply: Jan 29, 2015 8:54 AM by Kristan Sears RSS

    Load multiple files from multiple paths

    Kristan Sears

      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




      Wondering if this statement will work:



      LOAD filename,




      (ooxml, embedded labels, table is X);



      Thanks in advance