topic Re: Fetch multiple files | Qlik Sense S3 Connector in Connectivity & Data Prep

Fetch multiple files | Qlik Sense S3 Connector

shwetagupta — Tue, 28 Dec 2021 20:51:39 GMT

Hi fellas,

I am trying to fetch multiple files using AWS S3 Connector but for now what I can figure out is, we can fetch one file at a time using the web file connection on QLik sense.

i.e One link for one file

abc_2019jan.csv //one web link

abc_2019feb.csv // One new web link

Can I fetch this using a single link i.e by help of wildcard character (abc_2019*) or any other way?

Re: Fetch multiple files | Qlik Sense S3 Connector

jonathandienst — Fri, 22 Nov 2019 08:31:45 GMT

Web files and FTP do not support wild card loads. This is limited to files accessed through the file system.

If you know the web file names, you can use for each to loop over the files, but you will have to build the file list manually or in the load script before loading

For Each vFile in 'abc_2019jan.csv', 'abc_2019feb.csv'
... load the file named $(vFile)
Next

Re: Fetch multiple files | Qlik Sense S3 Connector

shwetagupta — Fri, 22 Nov 2019 08:59:31 GMT

Thanks Jonthdkpi!