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

      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