topic Re: loop through different excel files from Sharepoint in QlikView

loop through different excel files from Sharepoint

Fri, 15 Feb 2013 13:06:44 GMT

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

Re: loop through different excel files from Sharepoint

Wed, 15 Oct 2014 01:02:29 GMT

Hi Subhashish,

To access the share point files in Qlik server, where you are trying to deploy should be in same domain as that of share point and also the service account you are using should have the full access to the required share-point portal.

May be, these satisfy when you run it from local Machine and its doesn't when you run from server.

Re: loop through different excel files from Sharepoint

Thu, 23 Apr 2015 14:48:06 GMT

HI All,

I am facing the same problem can any one help me on this..?

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.

Re: loop through different excel files from Sharepoint

Mon, 10 Apr 2017 10:47:59 GMT

The URL should not be like 'http://servername/foldername/filename'

and it should be like '\\servername\foldername\filename.extension'.

QlikView cannot recognize the URL with HTTP for SharePoint.

In the above post the path is:

http://prime21.sharepoint.com/teams/BIS/Reporting/Offline files/Activity/*.xlsx

but it should be like:

\\prime21.sharepoint.com\teams\BIS\Reporting\Offline files\Activity\*.xls

then it will work.

Re: loop through different excel files from Sharepoint

Joost_d — Thu, 13 Dec 2018 10:00:15 GMT

Did it work?