Combining two columns into single column

[#1]

Hi,

I want to combine two columns say firstname and lastname into single column as name.

[its_anandrjs · Accepted solution]

Try with

Load

firstname,

lastname,

firstname &' '& lastname as name

From Location;

Regards

Anand

[Anonymous]

[firstname] & ' ' & [lastname] as Name ,