Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
shwetagupta
Partner - Creator II
Partner - Creator II

Fetch multiple files | Qlik Sense S3 Connector

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?

Labels (3)
1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
shwetagupta
Partner - Creator II
Partner - Creator II
Author

Thanks Jonthdkpi!