Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator III
Creator 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
Creator II
Creator II

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

please suggest me some other method rather than composite key?

Highlighted
Master III
Master 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
Contributor
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