topic Re: Load QVDs in QlikSense App in Connectivity & Data Prep

Load QVDs in QlikSense App

kashmoneybros — Thu, 23 Dec 2021 14:15:54 GMT

Hey guys,

I am a newbie in handling data on QlikSense. So my question might be very basic.

In my network folder I do have 10 folders with QVD in each of the folder. Basically the data can be connected through an ID. My basic question here is: how can I import all these QVDs via data load editor? Furthermore, the QVDs are updated daily.

If you need further information then ask me. Otherwise I'd be very delighted if anyone of you could help me out

Thanks

Kashmoneybros

Re: Load QVDs in QlikSense App

MayilVahanan — Wed, 11 Nov 2020 09:22:03 GMT

HI @kashmoneybros

Try like this

SET vDataPath = 'lib://YourfolderConnectionName\';

FOR Each vDir in DirList('$(vDataPath)*')

LOAD *
FROM
[$(vDir)\QvdName*.qvd](qvd);

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptControlStatements/For%20Each.htm?_ga=2.4143472.1354775969.1604240686-833360300.1599791395

Re: Load QVDs in QlikSense App

kashmoneybros — Wed, 11 Nov 2020 09:30:25 GMT

Thanks a lot for the quick response, Mayil. Can I use your code with the following folder structure as well:

Folder:

Folder 1:
- QVD
Folder 2:
- QVD
...
- QVD
Folder n:
- QVD

QVD are not in the same folder. Do I need to multiple your code then?

Thanks

Kashif

Re: Load QVDs in QlikSense App

kashmoneybros — Wed, 11 Nov 2020 13:25:48 GMT

Another question to you Mayil: do I have to define each path to folder with QVD with "SET vDataPath" expression?