topic Re: How to concatenate two fields (column) to make one in QlikView

How to concatenate two fields (column) to make one

Mon, 13 May 2013 11:26:52 GMT

Hello everyone,

I am tring to concatenate first_name with last_name.

so i want to display in following way

first_name last_name Full_mane

pankaj Patil pankaj patil \

tahnk u.

Re: How to concatenate two fields (column) to make one

its_anandrjs — Mon, 13 May 2013 11:32:28 GMT

Hi,

Load some thing like

first_name&' '&last_name as Full_Name

use & operator to concatenate.

Regards,

Anand

Re: How to concatenate two fields (column) to make one

calvindk — Mon, 13 May 2013 11:33:06 GMT

first_name & ' ' & last_name as full_name

Re: How to concatenate two fields (column) to make one

Mon, 13 May 2013 11:38:24 GMT

thankz I'm also searching that

Re: How to concatenate two fields (column) to make one

Tue, 30 Sep 2014 19:51:22 GMT

thanks much!

Re: How to concatenate two fields (column) to make one

sumitjadhav — Fri, 09 Oct 2015 10:59:38 GMT

please suggest me some other method rather than composite key?

Re: How to concatenate two fields (column) to make one

oknotsen — Fri, 09 Oct 2015 11:06:19 GMT

Combining the fields is THE way of doing this. This is not a composite key... this is just creating one field with what you want.

Re: How to concatenate two fields (column) to make one

Harshal_S — Thu, 16 May 2019 05:08:33 GMT

Hello i am aware of this procedure to concat two fields using "&" but can we do this generic/dynamic for all the fields in the load no matter how many fields there are

Re: How to concatenate two fields (column) to make one

Mahi — Sat, 26 Jun 2021 06:10:21 GMT

if conditions

Re: How to concatenate two fields (column) to make one

rajeshwar1 — Thu, 15 Jun 2023 04:00:46 GMT

yeah i need solution to this too