Joining fields from SQL database

[#1]

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

[maxgro]

load

     name,

     surname,

     name & ' ' & surname as [full name]

     ;

sql select

     name,

     surname

from

     yourtableinsqldatabase

     ;

[alexandros17]

If both field are in the same table then:

SELECT

     ...

     Name & ' ' & surname as completeName

      ....

From

     ....

[#4]

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

[Anonymous]

You can do it in SQL directly as well:

sql select

     name,

     surname

     name + ' ' + surname as FullName

from ...

[maxgro]

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

[#7]

Perfect! Thank you