Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

HELP NEEDED, load different data from multiple folders

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.

1 Reply
ekech_infomotio
Contributor II

Re: HELP NEEDED, load different data from multiple folders

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

Community Browser