Need help in loading binary image file in qlikview

[anilet123]

Hi,

I am trying to test loading binary image file from excel to qlikview. Following is my script.

Bundle

LOAD Id,

     Image

FROM

(ooxml, embedded labels, table is Sheet1);

After reload, only Id field is loaded not the Image field. Can anyone please help on this?

Attached the excel data.

[olivierrobin]

hello

the field image is not visible in table view

try to access it via qmem:// synatx

[anilet123]

Still not working..

[anilet123]

I tried direct load from database without preceding load  and it worked fine. When loaded using preceding load qlikview is converting images to random text.

BUNDLE INFO SELECT IMAGE_ID, IMAGE FROM BIDataWarehouse.dbo."STG_PER_IMAGES_TEST";