topic Re: Joining two fields from different tables in QlikView

Joining two fields from different tables

Wed, 14 Nov 2012 08:03:01 GMT

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,

Re: Joining two fields from different tables

jagan — Wed, 14 Nov 2012 08:25:06 GMT

Hi,

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

=surname & ' ' & [first name]

Hope this helps you.

Regards,

Jagan.

Re: Joining two fields from different tables

Anonymous — Wed, 14 Nov 2012 11:58:12 GMT

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

Re: Joining two fields from different tables

its_anandrjs — Wed, 14 Nov 2012 12:09:58 GMT

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