Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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