Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (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,