Loop through different folders in SharePoint

[apoorvasd]

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.

[tross2018]

@williamandersson 

No, the Qlik Data Gateway does not read excel files.  It allows connections from on prem sources to Qlik cloud only.  You'll see a (via Direct Access gateway) at the end of the connection name for connections going through the data gateway.

If you want to transfer excel files you need to use Qlik Data Transfer (QDT).  QDT can move excel or csv files from a network folder to Qlik cloud.  Note there is a limit of 200 files per folder location setup with QDT.