Qlik Community

Qlik Cloud Data Services

Discussion Board to explore in-depth resources and chat with Qlik Cloud Data Services experts from around the globe.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Creator III
Creator III

Qlik SAAS Loading wildcard (*.xlsx)

Hi Experts,

I am moving some apps over to the SAAS version of Qlik and while using the same script from the local version, i have found files cannot be loaded using the *.xlsx load to pull all data from a folder. is this the case? and s there an alternative sso that multiple files with the same headers can be loaded in one script?

 

Thank you

Daniel

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
Akshesh_Patel
Support
Support

Hi,

In SaaS, we cannot use a wildcard or masking syntax to only return files matching a specific pattern. Although, It would work if you used the attached files (lib://datafiles/), that would require you to upload all the needed files to the Qlik SaaS tenant.

Since you are migrating to SaaS, this might be helpful: https://help.qlik.com/en-US/migration/Content/Global_Common/Migrate/migrate-load-scripts.htm

 

Thank you,

View solution in original post

1 Reply
Akshesh_Patel
Support
Support

Hi,

In SaaS, we cannot use a wildcard or masking syntax to only return files matching a specific pattern. Although, It would work if you used the attached files (lib://datafiles/), that would require you to upload all the needed files to the Qlik SaaS tenant.

Since you are migrating to SaaS, this might be helpful: https://help.qlik.com/en-US/migration/Content/Global_Common/Migrate/migrate-load-scripts.htm

 

Thank you,