Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AlessandroPorcaro
Contributor
Contributor

Use of * for files in Amazon S3

Good morning everyone, I'm having problems loading files via an Amazon S3 connector.
The files have such a naming:
e.g. "Sales_yearmonthday" where "yearmonthday" is the date of the file.

I would like to make uploads from all files that have a name beginning with "Sales".
I used to use "Sales_*". The use of the asterisk "*" seems to work if I upload data from the DataFiles folder, but not from Amazon S3.

Does anyone have any idea why? Thank you in advance.

Labels (1)
1 Solution

Accepted Solutions
Levi_Turner
Employee
Employee

You didn't specify but I believe you are referring to Qlik SaaS (Qlik Cloud Services, Qlik Cloud Business). If so then this approach should work:

for each file in filelist('lib://Amazon_S3/')
    IF WildMatch('$(file)','*.qvd') THEN
      LOAD
          *
      FROM [$(file)](qvd);
    END IF
next file

View solution in original post

3 Replies
Levi_Turner
Employee
Employee

You didn't specify but I believe you are referring to Qlik SaaS (Qlik Cloud Services, Qlik Cloud Business). If so then this approach should work:

for each file in filelist('lib://Amazon_S3/')
    IF WildMatch('$(file)','*.qvd') THEN
      LOAD
          *
      FROM [$(file)](qvd);
    END IF
next file
AlessandroPorcaro
Contributor
Contributor
Author

Thanks Levi. 

Yes it is Qlik Cloud Services. These files are .xlsx and are loaded in Amazon S3. 

Do you think the same approach should run by substituting .qvd with .xlsx? 

Thanks a lot

Alessandro

Levi_Turner
Employee
Employee

Yep, you can substitute another file extension in there.