loop through different excel files from Sharepoint

[#1]

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

[#2]

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.

[#3]

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.

[#4]

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.

[Joost_d]

Did it work?