Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
random_user_3869
Partner - Creator III
Partner - Creator III

Load * from Sharepoint

Hello everyone,

Using Qlik Cloud i try to execute the command:

Table:

Load field_1,field_2

From file_*.csv

The issue is that i get error everytime while usinf the file_* instead of the complete name of the file.

Is there any workaround to solve the issue ?

Thank you

Labels (1)
  • Cloud

2 Replies
Corona55
Creator
Creator

You will need to specify the full file path with file name. file_* will not work in SharePoint connection for cloud. 
Office 365 Sharepoint | Qlik Connectors Help

 

You could use the Office 365 SharePoint Metadata to get the list of files and use that to loop through your files. 

 

 

SterreKapteijns
Partner - Creator
Partner - Creator

Indeed, wildcarts do not work with Sharepoint folder locations. 

First create an connection with the metadata: Office 365 SharePoint Metadata | Qlik Connectors Help
Then select data, and use the table 'ListFiles' to get the list of files present in the folder. Then create an for-loop to loop over these files and load the data with the filename as variable.