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')
PS: Service account does have full access to this site in SharePoint.