topic Re: HELP NEEDED, load different data from multiple folders in QlikView

HELP NEEDED, load different data from multiple folders

Fri, 17 Feb 2012 13:57:15 GMT

Hello QV users,

First of all I'm looking for a piece of script thats helps me with loading data (csv and jpg) in different (main)folders with an same subfolder named DATA.

it's looking like:

All stored on a central-disk:

- MainFolder (Different names)

- SubFolder (called DATA)

Subfolder contains files witch should be loaded into QV, lot's of CSV-files (formated all equal) and JPG.

I hope someone can help me?

Second:

If its possible i also want to create a hyperlink in the script for 2 main items in the CVS file. There are 2 fields (different names, pic1, pic2) witch rever to the JPG files in the ' DATA' folder.

I dont want to load de pic's into the dashboard (the file becomes to great) but just want a hyperlink to open the pic or show it in the dashboard within an textblok.

Re: HELP NEEDED, load different data from multiple folders

ekech_infomotio — Fri, 17 Feb 2012 14:18:27 GMT

Did you know that QV has a help which is worth to look at?

Assuming you have a basic knowledge of Qlikview and it's scripting language:

for each vMainFolder in '\\this\is\your\first\MainFolder', '\\this\is\your\second\MainFolder', ..., '\\this\is\your\n-th\MainFolder'

for each vCSVfile in filelist($( vMainFolder)&' \DATA\*.csv')

load

whatever_is_in_this_file,

'$(vCSVfile)' as CSV_Name,

'$(vMainFolder)\DATA\' & jpg_filename_found_in_your_csv as JPG_Name

from

$(vCSVfile)

;

next vCSVfile

;

for each vJPGfile in filelist($( vMainFolder)&' \*.jpg')

[never tested loading jpg-files]

next vJPGfile

;

next vMainFolder

;

hope this will help a little bit.

regards,

Edgar