Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Load FIRST_NAME, LAST_NAME, FIRST_NAME & ' ' & LAST_NAME as Full_Name
From (Whatever);
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;