Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Thanks Jonthdkpi!