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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Specialist
Specialist

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 (2)
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,