topic Re: Need help in loading binary image file in qlikview in QlikView

Need help in loading binary image file in qlikview

anilet123 — Thu, 04 Oct 2018 07:08:48 GMT

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.

Re: Need help in loading binary image file in qlikview

olivierrobin — Thu, 04 Oct 2018 08:41:02 GMT

hello

the field image is not visible in table view

try to access it via qmem:// synatx

Re: Need help in loading binary image file in qlikview

anilet123 — Thu, 04 Oct 2018 10:36:22 GMT

Still not working..

Re: Need help in loading binary image file in qlikview

anilet123 — Thu, 04 Oct 2018 10:50:35 GMT

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";