create multiple fields from one

[mparker123]

Hello All,

In my script i have the below expression. I am pulling this information in through an excel file. First_Name and Last_Name are filed names. I am joining them to make Full_Name. Is there a way to keep the below expression but also make Last_Name it's one field so i can sort by it?

FIRST_NAME & ' ' & LAST_NAME as Full_Name

[Or]

Load FIRST_NAME, LAST_NAME, FIRST_NAME & ' ' & LAST_NAME as Full_Name

From (Whatever);

[Anil_Babu_Samineni]

May be load excel first and Add one more field called

Load FIRST_NAME,

        LAST_NAME,

        FIRST_NAME & ' ' & LAST_NAME as Full_Name

From Excel;