topic Re: Jou data from two columns into one in QlikView

Jou data from two columns into one

Fri, 12 Oct 2012 19:44:34 GMT

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

Re: Jou data from two columns into one

johnw — Fri, 12 Oct 2012 19:52:06 GMT

First_name & ' ' & Last_Name as Full_name,

Re: Jou data from two columns into one

MayilVahanan — Fri, 12 Oct 2012 19:53:28 GMT

Try like this

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

Hope that helps

Re: Jou data from two columns into one

Sat, 13 Oct 2012 23:40:06 GMT

Thank you