topic Concatenate 2 fields in QlikView

Concatenate 2 fields

Wed, 25 Nov 2020 16:16:04 GMT

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"

Re: Concatenate 2 fields

sunny_talwar — Thu, 15 Sep 2016 16:45:10 GMT

May be try this in the preceding load

LOAD *,

"cust_first_name" & ' ' & "cust_last_name" as [cust_full_name];

SQL SELECT "country_id",

"cust_city",

"cust_city_id",

"cust_credit_limit",

"cust_eff_from",

"cust_eff_to",

"cust_email",

"cust_first_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";

Re: Concatenate 2 fields

swuehl — Thu, 15 Sep 2016 16:48:03 GMT

Check the syntax for a concatenation operator for your DBMS.

Instead of & operator, some systems use different operators like || or +