2 Replies Latest reply: Jun 15, 2017 1:43 PM by Bakul Ranawat RSS

    Convert blob (UTF8) i.e. Byte Array data into text for a column in a table.

    Bakul Ranawat

      I need to convert blob (UTF8) i.e. Byte Array data into text for a column in my table.

       

      One of my reports need to get data from an DB2 database, which i am able to successfully connect.  But the column i am looking for is stored as BLOB though the content is string (text). Qlik read's the data but is of no use as it is displayed as numbers. For example the text 'unable.. looks like '54686973206...

       

      I was looking for a way if i can convert/cast the column data into text in Qlik.