Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
apoorvasd
Creator II
Creator II

Loop through different folders in SharePoint

Hello Everyone,

I am trying to loop through excel files present in SharePoint using "for each" loop as shown below. But not sure why, the loop statement doesn't work and there is no data fetched into QlikView. Can anyone guide me here please?

for each FoundFile in filelist ('http:servername/processes/ab/abc/abcd/xy%20xyz%202017%20-%20Region%20Plant\FileName*.xlsx')

FileList:

load

A,

B

C

FROM $(FoundFile)

(ooxml...);

next FoundFile;


PS: Service account does have full access to this site in SharePoint.

Thank you.

4 Replies
Anil_Babu_Samineni

When you say share point? Are you getting data using single excel instead of multiple?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
apoorvasd
Creator II
Creator II

No there are multiple excel files.

Enriquemmesteo
Creator
Creator

Did you ever solve this? I have the same issue

marcus_sommer
MVP & Luminary
MVP & Luminary

A sharepoint isn't a classical file-storage and therefore the usual file-functions/operations won't work:

https://community.qlik.com/... &q=sharepoint%20 

- Marcus