Jou data from two columns into one

[#1]

Hi, I have a data base where the first name and the last name are in different columns. I need them in one column, can I join the information into a column directly from the script?

First_name    Last_name

xx                    yyy

And I need the information in one column:

Full_name

xx yyy

Thank you

[johnw]

First_name & ' ' & Last_Name as Full_name,

[MayilVahanan · Accepted solution]

HI

Try like this

Load First_name &' '&Last_name as Full_name ,* from tablename;

Hope that helps

[#4]

Thank you