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

[rish_sai]

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);

[oknotsen]

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

[sunny_talwar · Accepted solution]

So for example:

LOAD EmpID as EmployeeID,

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

          ...

[rish_sai]

Thanks