Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rish_sai
Contributor III
Contributor III

how to combine last names and first name in qlikview back end script

Hi,

how to combine write last name and first name (or)street, city , state , country into one column in qlikview

LOAD EmpID as EmployeeID,

     [First Name],[Last Name],

     

     Title,

     [Hire Date],

     Office,

     Extension,

     [Reports To],

     [Year Salary]

FROM

(qvd);

1 Solution

Accepted Solutions
sunny_talwar

So for example:

LOAD EmpID as EmployeeID,

          [First Name] & ' ' & [Last Name] as [Full Name],

          ...

View solution in original post

3 Replies
oknotsen
Master III
Master III

To combine fields, use the "&" symbol between the fields and add "as nameOfNewField" to the end.

May you live in interesting times!
sunny_talwar

So for example:

LOAD EmpID as EmployeeID,

          [First Name] & ' ' & [Last Name] as [Full Name],

          ...

rish_sai
Contributor III
Contributor III
Author

Thanks