Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try using to_char() in the SQL SELECT script and trim() function in the LOAD script