topic Extracting data from Memo fields in SQL in QlikView

Extracting data from Memo fields in SQL

Mon, 23 Jan 2012 10:35:41 GMT

Hi all,

I need to extract a piece of information from a memo/blob field in SQL, can Qlikview do this and if so does anybody know the way to go about doing this?

Any help would be greatly appreciated.

Kind regards,

Steven Prentice

Extracting data from Memo fields in SQL

stephencredmond — Mon, 23 Jan 2012 10:40:22 GMT

Hi Steven,

QlikView can read memo fields so it really depends on the way the data is in the field and what you need to get out of it.

Regards,

Stephen

Extracting data from Memo fields in SQL

Mon, 23 Jan 2012 11:07:55 GMT

Thanks very much. Basically the memo field is just broken up into different section access defined by [ ]. I need to extract the information beneath one of these headers only.

How do you load blob fields into Qlikview?

When I select Blobs on the load, it sayd Blobs not supported with this type of connection, SQL OLE DB.

Thanks,

Steven

Extracting data from Memo fields in SQL

stephencredmond — Mon, 23 Jan 2012 11:25:44 GMT

Hi Steven,

I don't know what version of the SQL driver you are using but I don't remember ever having issues with TEXT fields. Perhaps make sure that you are using the latest SQL Native client driver.

You might have a problem with non TEXT blob fields such as image. Then you will need to craft your SQL to return text. Something like this:

SQL SELECT ID, CONVERT(Varchar(1024), convert(varbinary(1024),BLOB_FIELD)) as BLOB_FIELD FROM [dbo].[Blob_Table];

Regards,

Stephen

Re: Extracting data from Memo fields in SQL

Fri, 28 Jun 2013 19:24:37 GMT

I have a similar issue- I am reading Oracle DB through OLE DB. I have a field that is a BLOB. I am able to read it into QV but it is still encoded. How do I decode/convert to text so that I can parse the field? (BTW...I tried the CONVERT above and got an error.) Thanks.