Use of * for files in Amazon S3

[AlessandroPorcaro]

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.

[Levi_Turner · Accepted solution]

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]

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]

Yep, you can substitute another file extension in there.