Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.