Data mismatches between source and Qlikview

Fri, 12 Feb 2016 13:04:44 GMT

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.?

Re: Data mismatches between source and Qlikview

Gysbert_Wassenaar — Sat, 13 Feb 2016 14:38:30 GMT

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...

;

topic Re: Data mismatches between source and Qlikview in QlikView

Data mismatches between source and Qlikview

Re: Data mismatches between source and Qlikview