topic Strang value when loading from ODBC table!! in QlikView

Strang value when loading from ODBC table!!

Wed, 08 Feb 2012 16:34:04 GMT

HI,

I am loading data from ODBC table and one of the fields is the State.

When I load it to Qlikview it transulate the text to a strang value..such as GA is showing as C6D340!!

Anybody knows what type of value is that ?? Hex? Binary..and how to fix the transulation?

Thanks

stephencredmond — Wed, 08 Feb 2012 17:16:10 GMT

Hi,

Looks like some sort of encoded value. What kind of database is it? Is there an option in the odbc setup to handle encoded vales?

Regards,

Stephen

Wed, 08 Feb 2012 17:23:09 GMT

Well, I just found out how to do it.

I used the follwing in my query:

CAST(F.ALADDS AS CHAR(20) CCSID 37)AS ShpToState,

where F.ALADDS is the filed needed to be fixed.