Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
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
its_anandrjs

Hi,

Load some thing like

first_name&' '&last_name as Full_Name

use & operator to concatenate.

Regards,

Anand

View solution in original post

8 Replies
its_anandrjs

Hi,

Load some thing like

first_name&' '&last_name as Full_Name

use & operator to concatenate.

Regards,

Anand

View solution in original post

calvindk
Creator III
Creator III

first_name & ' ' & last_name as full_name

Not applicable
Author

thankz I'm also searching that

Not applicable
Author

thanks much!

sumitjadhav
Creator II
Creator II

please suggest me some other method rather than composite key?

oknotsen
Master III
Master III

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!
Harshal_S
Contributor
Contributor

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

Mahi
Contributor
Contributor

if conditions