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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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,