Discussion Board for collaboration on QlikView Scripting.
How can I connect 2 fields like "name" and "surname" to "full name" coming from an sql database?
name & ' ' & surname as [full name]
If both field are in the same table then:
Name & ' ' & surname as completeName
ok, thank you . so you have to insert the merge command before loading the data from the sql databse?
You can do it in SQL directly as well:
name + ' ' + surname as FullName
there are different ways
- only sql side (Michael, Alessandro)
- mixed (sql + qlik) with concat in sql
- mixed with concat in qlik (Massimo)
Perfect! Thank you