Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Tags (1)
1 Solution

Accepted Solutions

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

So for example:

LOAD EmpID as EmployeeID,

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

          ...

View solution in original post

3 Replies
oknotsen
Honored Contributor III

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

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

May you live in interesting times!

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

So for example:

LOAD EmpID as EmployeeID,

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

          ...

View solution in original post

rish_sai
New Contributor III

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

Thanks