Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am new to Qlikview
I'd like to concatenate 2 fields cust_first_name and cust_last_name.
I am using the & operator for that purpose.
But I always get an error message when I try to reload the data.
Your help is appreciated. Please see below error message
SqlState: 42883, ErrorCode: 7, ErrorMsg: ERREUR:operator does not exist : character varying & unknown;
Error while executing the query
SQL SELECT "country_id",
"cust_city",
"cust_city_id",
"cust_credit_limit",
"cust_eff_from",
"cust_eff_to",
"cust_email",
"cust_first_name",
"cust_first_name" & ' ' & "cust_last_name",
"cust_gender",
"cust_id",
"cust_income_level",
"cust_last_name",
"cust_main_phone_number",
"cust_marital_status",
"cust_postal_code",
"cust_src_id",
"cust_state_province",
"cust_state_province_id",
"cust_street_address",
"cust_total",
"cust_total_id",
"cust_valid",
"cust_year_of_birth"
FROM "drugs"."public"."customers"
May be try this in the preceding load
LOAD *,
"cust_first_name" & ' ' & "cust_last_name" as [cust_full_name];
FROM "drugs"."public"."customers";
Check the syntax for a concatenation operator for your DBMS.
Instead of & operator, some systems use different operators like || or +
