Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
shwetagupta
Partner
Partner

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 (6)
1 Solution

Accepted Solutions
jonathandienst
Partner
Partner

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
Partner

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

shwetagupta
Partner
Partner
Author

Thanks Jonthdkpi!