16 Replies Latest reply: May 23, 2016 8:15 AM by Tamil Nagaraj RSS

    Loading Excel Files from multiple Folders

    Ridhaa Hendricks

      Hi There

       

      I need to be able to load all files from all folders within a specific folder.

       

      I have tried the below piece of script. but when running it returns no data.

       

      I have the folder structure like this.

       

      C:\Users\Rido\Desktop\Test\2016\Jan

       

      my file name is TestData.xlsx and is in the Jan folder

       

      I need to be able to pull all the files from my Test folder no matter the year no matter the month .

       

       

      let vAllPath='C:\Users\Rido\Desktop\Test\*.xlsx';

      for each File in filelist (vAllPath)


      AllDATA:
      LOAD Cars,
      Date,
      Value
      FROM
      $(File)
      (
      ooxml, embedded labels, table is Sheet1);

      next File

       

       

        Any Assistance is appreciated