Qlikview Import All Images in Folder

[#1]

HI There,

Is there anyway to import a batch of pictures into qlikview?

I would like to import the images into 1 column and import the file names into another column?

Kind Regards

[nagaiank]

Did you try BUNDLE prefix in the LOAD statement? The details are in the Qlikview Reference Manual.

[#3]

hi krishamoorthy,

thank you for your reply. If I understand correctly, the bundle load picture will import binary BLOB data and not all the pictures in 1 folder that i have.

I would for qlikview to load all the images as well as their corresponding file names

Please let me know if you know of any way that i can achieve this

Kind Regards

[#4 · Accepted solution]

Hi to all,

I have found the solution in the following blog:

http://community.qlik.com/message/161553

To load all the images into the qvw would be insane. So the best method as described from the blog above is to reference the images and allow qlikview to point to the image files using the method below

for each image in filelist ('*.png'); // Here it loads png image
let j= subfield(subfield(image,'\',-1),'.',1);

Smiley: // Table name
LOAD * INLINE [
    Smile, Location // Fields under the table
    $(j), $(image) // Image name and the location
    ];    
next image; // loop to load all images