Wondering if it is possible to load a range of files creating the filename from a list of values in a csv?
If I want to load all the files that contain data for Q2 of 2022 in the format sales-<Month>-<Year>.qvd (eg sales-Jun-2022.qvd) and using a csv containing data as below to do so:
So basically the script will then load files containing the filename Apr-2022,May-2022,Jun-2022,Jul-2022
Is this possible?
Yes, it's possible.
Check out https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543.
This post is about QlikView, but it is still relevant. The difference is that in Qlik Sense you need to use a Lib:// reference instead of a file system reference.
View solution in original post
Thanks Henric, I've actually mistakenly posted this in QS instead of QV so this should be great, I'll have a look