Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

4 Replies
Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

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
Partner - Contributor
Partner - Contributor

Did it work?