Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Country code varchar2 issue

Team

   I am having two table one for country and client transaction, they kept the country code as varchar2 at oracle. I could not able to match the values based on country code.

country

country_code - varchar2

country_name - char

client_transaction

client_id  - Number

Amount  - Number

country_code - varchar2

Can any one suggest me how can  we convert the varchar2 to character in qlikview to match the codes

country code  details

MEX

ARG

USA

1 Reply
boorgura
Specialist
Specialist

try using to_char() in the SQL SELECT script and trim() function in the LOAD script