Load QVDs in QlikSense App

[kashmoneybros]

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

[MayilVahanan]

HI @kashmoneybros 

Try like this

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

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

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

NEXT

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptControlS...

[kashmoneybros]

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

[kashmoneybros]

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