topic Re: Concatenate two fields in QlikView

Concatenate two fields

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Good day,

I have a Customer field and a CustomerID field that I need to combine as one.

I believe the text should be:

CustomerID&" "&Customer name as Customer_Name

Is this correct and where and how should I define this to create the new combined field?

Please help!

Re: Concatenate two fields

Tue, 26 Jul 2016 20:23:41 GMT

this almost correct. correct in the case would be CustomerID&' '&Customer name as Customer_Name

you implement in you script

example:

load

CustomerID&' '&Customer name as Customer_Name,

CustomerID,

[Customer name]

from source...

Re: Concatenate two fields

vinieme12 — Tue, 26 Jul 2016 20:23:44 GMT

if you don't want to add a separator to distinguish then this is fine

Remember fieldname with spaces need to placed in square brackets

CustomerID&[Customer name] as Customer_Name

CustomerID&'-'&[Customer name] as Customer_Name (use a hyphen or _ underscore)

Cheers

Re: Concatenate two fields

Anonymous — Tue, 26 Jul 2016 20:50:31 GMT

I have first created an inline table and then on top of that using preceding load ! created [Customer Name]. If you are exporting value from some external data file, in the same stage you can write the code [Customer ID] & ' ' & Customer as [Customer Name] and create the new field.

I have created a qvw for you in the attachment.

LOAD *,

[Customer ID] & ' ' & Customer as [Customer Name];

LOAD * INLINE [

Customer ID, Customer

1, AB

2, BC

3, CD

4, DE

5, EF

];

Re: Concatenate two fields

Anonymous — Tue, 26 Jul 2016 21:04:01 GMT

Hi,

Thank you for your quick response. I don't see the attachment though (or am I just being stupid?).

Regards

Re: Concatenate two fields

Anonymous — Tue, 26 Jul 2016 21:47:46 GMT

I have attached again

Re: Concatenate two fields

avinashelite — Wed, 27 Jul 2016 03:19:04 GMT

I suggest to with

CustomerID&'-'&[Customer name] as Customer_Name

having space in the Key doesn't sounds good.

Re: Concatenate two fields

Chanty4u — Wed, 27 Jul 2016 03:46:48 GMT

try this

CustomerID&"_"&[Customer name] as Customer_Name

Re: Concatenate two fields

engishfaque — Wed, 27 Jul 2016 11:29:45 GMT

Dear Martin,

Field Concatenation:

Use single quote instead of double quote and use brackets when you have a field name with space such as given below,

CustomerID & ' ' & [Customer name] as Customer_Name

Kind regards,

Ishfaque Ahmed