topic How to view a BLOB on Qlikview? in QlikView

How to view a BLOB on Qlikview?

suraj_qlikdev — Wed, 25 Nov 2020 16:16:04 GMT

We have our data in the BLOB.

Currently I am stuck at this point.

Re: How to view a BLOB on Qlikview?

swuehl — Wed, 23 Mar 2016 21:08:20 GMT

Maybe have a look at

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

Re: How to view a BLOB on Qlikview?

suraj_qlikdev — Wed, 23 Mar 2016 21:28:15 GMT

Thanks for your reply, swuehl.

I looked at the post and learned that Qlikview supports jpg, png, bmp, pdf and rtf formats.

As I still don't see any data for the BLOB field should I assume my BLOB data is not one of the supported formats as mentioned above?

I will find out the my BLOB data format and will check back.

Re: How to view a BLOB on Qlikview?

santiago_respane — Wed, 23 Mar 2016 21:36:11 GMT

Hi,

maybe something like this:

INFO SELECT Imagename, Image FROM Imagetable;

BUNDLE INFO LOAD Imagename, Image ;

SELECT DISTINCT Imagename,Image FROM Imagetable;

Let me know if it works.

Regards,

Re: How to view a BLOB on Qlikview?

suraj_qlikdev — Wed, 23 Mar 2016 22:02:30 GMT

Thanks for your reply,

I tried the ones you've mentioned but it didn't work. I still see binary values in the field.

May be the data in BLOB has a different file format. I am checking the same with my DBA.

Re: How to view a BLOB on Qlikview?

suraj_qlikdev — Thu, 24 Mar 2016 15:28:46 GMT

The above is the response for my question to find out the data format of the blob. We know that Qlikview supports only limited formats as I mentioned in my previous replys.

Could someone let me know what would be the best way I can bring this data onto Qlikview may be something like converting to readable format in any other applications?

Based on my requirement I should bring this blob data on to my qlikview applications.