topic Re: Load range of files based on a csv list in App Development

Load range of files based on a csv list

neil-devlin — Wed, 20 Jul 2022 11:44:33 GMT

Hi,

Wondering if it is possible to load a range of files creating the filename from a list of values in a csv?

For example:

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?

Re: Load range of files based on a csv list

hic — Wed, 20 Jul 2022 11:49:31 GMT

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.

Re: Load range of files based on a csv list

neil-devlin — Wed, 20 Jul 2022 11:51:47 GMT

Thanks Henric, I've actually mistakenly posted this in QS instead of QV so this should be great, I'll have a look