topic Re: Qlikview Import All Images in Folder in QlikView

Qlikview Import All Images in Folder

Sun, 08 Jul 2012 09:58:32 GMT

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

Re: Qlikview Import All Images in Folder

nagaiank — Sun, 08 Jul 2012 15:13:30 GMT

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

Re: Qlikview Import All Images in Folder

Sun, 08 Jul 2012 19:14:23 GMT

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

Re: Qlikview Import All Images in Folder

Mon, 09 Jul 2012 09:08:46 GMT

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