topic Re: create multiple fields from one in QlikView

create multiple fields from one

mparker123 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: create multiple fields from one

Or — Tue, 19 Dec 2017 13:47:18 GMT

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

From (Whatever);

Re: create multiple fields from one

Anil_Babu_Samineni — Tue, 19 Dec 2017 13:48:24 GMT

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;