topic Re: Load multiple qvd files in QlikView

Load multiple qvd files

Tue, 30 Oct 2012 11:53:34 GMT

Hello Friends,

I have around 30 qvd files in a folder, I need to load it all in a single block.

Is it possible.

Regards

Chriss

Re: Load multiple qvd files

Gysbert_Wassenaar — Tue, 30 Oct 2012 11:58:49 GMT

Something like this:

Set vFolder = 'C:\QVD';

for each File in filelist($vFolder& '\*.qvd')

load * from [$(File)] (qvd);

next File

Re: Load multiple qvd files

Tue, 30 Oct 2012 12:13:44 GMT

Hello Gysbert,

Thanks for your reply, as what you said I tried like the following. but its taking different qvd from the root folder.

what I have to give in the filelist and I don't know where I am making a mistake, could you please help me

Set vFolder = 'D:\New Leads\QVD';

for each File in filelist($vFolder& '\*.qvd')

load * from [$(File)] (qvd);

next File

Regards

Chriss

Re: Load multiple qvd files

Gysbert_Wassenaar — Tue, 30 Oct 2012 12:32:52 GMT

Oops, tripped up again by variable variety. No $-expansion for vFolder in this case. Try instead:

Set vFolder = 'D:\New Leads\QVD';

for each File in filelist(vFolder& '\*.qvd')

load * from [$(File)] (qvd);

next File

Re: Load multiple qvd files

Tue, 30 Oct 2012 12:34:40 GMT

You could also do:

Table1:

Load * from $(vDirectory)\*.qvd;

Be advised that you loose debugging capability if you do so.

Dion

Re: Load multiple qvd files

Tue, 30 Oct 2012 12:36:21 GMT

Hello Gysbert,

Thanks a lot... it works..

Regards

Chriss

Re: Load multiple qvd files

Tue, 29 Aug 2017 13:36:57 GMT

@gwassenaar your script helped me to read qvd in a folder with many files. I am trying to figured out the need for '\*

to me seems an escape for ' symbol but I am not sure. Could you provide an hit on this?

Thank you

Carmine

Re: Load multiple qvd files

Gysbert_Wassenaar — Wed, 30 Aug 2017 10:14:50 GMT

It's not an escape. It's necessary to create a full path to the files you want to load.

If vFolder is 'D:\New Leads\QVD' then vFolder & '\*.qvd' gives 'D:\New Leads\QVD\*.qvd'

Re: Load multiple qvd files

KundanJyothsna — Fri, 01 Nov 2019 08:34:43 GMT

I am able to load the script and went out successfully with all the qvds in qlikview , but the same code is not working in qliksense.

The "File" variable is fetching as NULL.Can u please suggest anything on this.

Regards

Jyothsna Kundan

Re: Load multiple qvd files

Gysbert_Wassenaar — Mon, 11 Nov 2019 10:37:44 GMT

In QlikSense you need to use a folder connection: FileList('LIB://MyFolder/*.qvd')

Re: Load multiple qvd files

mmainiero — Tue, 29 Mar 2022 10:55:17 GMT

Is it possible to load only a certian number of files e.g. only last 10?

Or if the Files contain a Date "File_20220321" to load only files withe filenames greater as?