3 Replies Latest reply: Apr 10, 2017 6:47 AM by jhanaarthanan gopalan RSS

    loop through different excel files from Sharepoint

      Dear All,

       

      I am facing an issue while looping through multiple excel files from a share point.

       

      it works fine when i give a local path but not from sharepoint.

       

       

      FOR each File in filelist ('http://prime21.sharepoint.com/teams/BIS/Reporting/Offline files/Activity/*.xlsx')
      
      
      CrossTable(FundName, FundData, 97)
      
      ActivityNew:
        LOAD *
      
            FROM [$(File)] (ooxml, embedded labels);
      
       NEXT File ;
      
      Store ActivityNew into C:\Users\mishsubh\Desktop\Final Q2C\Activity.Qvd;
      
      Drop table ActivityNew;
      
      

       

       

      any help is really appriciaed.

       

      Regards,

      Subhashish