Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Jou data from two columns into one

Hi, I have a data base where the first name and the last name are in different columns. I need them in one column, can I join the information into a column directly from the script?

First_name    Last_name

xx                    yyy

And I need the information in one column:

Full_name

xx yyy

Thank you

1 Solution

Accepted Solutions

Re: Jou data from two columns into one

HI

Try like this

Load First_name &' '&Last_name as Full_name ,* from tablename;

Hope that helps

3 Replies
MVP
MVP

Re: Jou data from two columns into one

First_name & ' ' & Last_Name as Full_name,

Re: Jou data from two columns into one

HI

Try like this

Load First_name &' '&Last_name as Full_name ,* from tablename;

Hope that helps

Not applicable

Re: Jou data from two columns into one

Thank you

Community Browser