Joining two fields from different tables

[#1]

Ho w do you join two fields in
qlikview from two different tables in the front end

like surname in client table and first name in policy table

thanks,

[jagan]

Hi,

If there is a relation between these two tables then you can use

=surname & ' ' & [first name]

Hope this helps you.

Regards,

Jagan.

[Anonymous]

What Jagan's suggsted is the best but in case the tables are not associate then you can use lookup function to bring surname from client table.

hope this helps!

Regards

MultiView

[its_anandrjs]

Hi,

If the relation ships between table is there so it is good otherwise i suggest make resident table and create a single table with first name and surname.

If there is relation so it will obtain by

=Table1.surname& '-' &Table2.firstname

HTH

Regards,

Anand