2 Replies Latest reply: Dec 6, 2012 1:48 PM by jluis_p2 RSS

    Loading Multiple Excel Files In qlikview  through Loop

      Hiii

       

      I have 30 multiple excel sheet that i have to fetch in qlikview, without fetching it again and again. I just want to reload the application one time and the whole excel sheet should be fetched (in one time) and qvd should me made.

        • Re: Loading Multiple Excel Files In qlikview  through Loop
          Neha Rangari

          Hi,

           

          You can use following script:

           

          Load *

          From $(Path)\*.xls

          (biff, embedded labels, table is Sheet1$);

           

          Regards,

          Neha

          • Re: Loading Multiple Excel Files In qlikview  through Loop

            HI:

             

            This is my first time posting something, i hope this respond your question:

            replay.png

             

            LET vDataFolder = 'C:\Users\mxparedesjl\Desktop\TP_Tecnicos\DB\';
            LET vFileName = '';

            for Each vFile in FileList('$(vDataFolder)158*.xlsx')

            let vFileName = mid(vFile, (index(vFile, '\', -1) + 1),8);

            [Engineers]:
            LOAD
              $(vFileName)                  AS [Number],
              MakeDate(SubField(Day, '.', 3),SubField(Day, '.', 2),SubField(Day, '.', 1))  AS [Date],
                 Wk.time                   AS [Time],
                 Doc.                    AS [Document],
                 (Differenc * -1)                 AS [Diferrence]
            FROM $(vFile)
            (ooxml, embedded labels, header is 3 lines, table is $(vFileName));
            NEXT