Data mismatches between source and Qlikview

[#1]

Hi ,

I have Apache Hbase as my source. Now I am extracting data from hbase to Qlikview using Amazon EMR ODBC driver.

I observed that some of the loaded columns are not matching with hbase data.

For example.  in Hbase a particular column called RSN_SR_KEY contains data as 1,2

But after loading that column into Qlikview, the data shown is 49,50.

Can any one know the reason and a way to rectify/overcome this error.?

[Gysbert_Wassenaar]

Perhaps the RSN_SR_KEY values are really numbers like 49 and 50, but show as ascii characters. Chr(49) is 1, Chr(50) = 2. Try using the Chr() function on the column:

LOAD

     ...some fields...,

     Chr(RSN_SR_KEY) as RSN_SR_KEY,

     ...some other fields...

FROM

     ....hbase table...

     ;