How to concatenate two fields (column) to make one

[#1]

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.

[its_anandrjs · Accepted solution]

Hi,

Load some thing like

first_name&' '&last_name as Full_Name

use & operator to concatenate.

Regards,

Anand

[calvindk]

first_name & ' ' & last_name as full_name

[#4]

thankz I'm also searching that

[#5]

thanks much!

[sumitjadhav]

please suggest me some other method rather than composite key?

[oknotsen]

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.

[Harshal_S]

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]

if conditions

[rajeshwar1]

yeah i need solution to this too