Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn 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 (2)
2 Replies
TheLazyDevelopr
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 Ambassador
Partner Ambassador

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.