Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

How to concatenate two fields (column) to make one

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.

1 Solution

Accepted Solutions
Highlighted

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

Hi,

Load some thing like

first_name&' '&last_name as Full_Name

use & operator to concatenate.

Regards,

Anand

View solution in original post

7 Replies
Highlighted

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

Hi,

Load some thing like

first_name&' '&last_name as Full_Name

use & operator to concatenate.

Regards,

Anand

View solution in original post

Highlighted
calvindk
Contributor III

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

first_name & ' ' & last_name as full_name

Highlighted
Not applicable

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

thankz I'm also searching that

Highlighted
Not applicable

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

thanks much!

Highlighted
sumitjadhav
Contributor II

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

please suggest me some other method rather than composite key?

Highlighted
oknotsen
Honored Contributor III

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

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.

May you live in interesting times!
Highlighted
Harshal_S
New Contributor

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

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