Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Joining fields from SQL database

How can I connect 2 fields like "name" and "surname" to "full name" coming from an sql database?

6 Replies
maxgro
MVP
MVP

load

     name,

     surname,

     name & ' ' & surname as [full name]

     ;

sql select

     name,

     surname

from

     yourtableinsqldatabase

     ;

alexandros17
Partner - Champion III
Partner - Champion III

If both field are in the same table then:

SELECT

     ...

     Name & ' ' & surname as completeName

      ....

From

     ....

Not applicable
Author

ok, thank you . so you have to insert the merge command before loading the data from the sql databse?

Anonymous
Not applicable
Author

You can do it in SQL directly as well:

sql select

     name,

     surname

     name + ' ' + surname as FullName

from ...

maxgro
MVP
MVP

there are different ways

- only sql side (Michael, Alessandro)

- mixed (sql + qlik) with concat in sql

- mixed with concat in qlik (Massimo)

.more here

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load

Not applicable
Author

Perfect! Thank you