topic Re: Joining fields from SQL database in QlikView

Joining fields from SQL database

Tue, 27 May 2014 14:56:21 GMT

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

maxgro — Tue, 27 May 2014 14:59:43 GMT

load

name,

surname,

name & ' ' & surname as [full name]

;

sql select

name,

surname

from

yourtableinsqldatabase

;

alexandros17 — Tue, 27 May 2014 15:00:36 GMT

If both field are in the same table then:

SELECT

...

Name & ' ' & surname as completeName

....

From

....

Tue, 27 May 2014 15:01:12 GMT

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

Anonymous — Tue, 27 May 2014 15:03:21 GMT

You can do it in SQL directly as well:

sql select

name,

surname

name + ' ' + surname as FullName

from ...

maxgro — Tue, 27 May 2014 15:11:44 GMT

there are different ways

- only sql side (Michael, Alessandro)

- mixed (sql + qlik) with concat in sql

- mixed with concat in qlik (Massimo)

.more here

Tue, 27 May 2014 15:15:29 GMT

Perfect! Thank you