How to view a BLOB on Qlikview?

[suraj_qlikdev]

We have our data in the BLOB.

Currently I am stuck at this point.

[swuehl]

Maybe have a look at

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

[suraj_qlikdev]

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.

[santiago_respane]

Hi,

maybe something like this:

INFO SELECT Imagename,  Image FROM Imagetable;

or

BUNDLE INFO LOAD Imagename, Image ;

SELECT DISTINCT Imagename,Image FROM Imagetable;

Let me know if it works.

Regards,

[suraj_qlikdev]

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.

[suraj_qlikdev]

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.