Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
So for example:
LOAD EmpID as EmployeeID,
[First Name] & ' ' & [Last Name] as [Full Name],
...
To combine fields, use the "&" symbol between the fields and add "as nameOfNewField" to the end.
So for example:
LOAD EmpID as EmployeeID,
[First Name] & ' ' & [Last Name] as [Full Name],
...
Thanks