topic Re: Joining on Multiple fields in QlikView https://community.qlik.com/t5/QlikView/Joining-on-Multiple-fields/m-p/705815#M254455 <HTML><HEAD></HEAD><BODY><P>you need to identify key columns (aka composite key) in both tables</P></BODY></HTML> Tue, 16 Sep 2014 07:28:52 GMT Anonymous 2014-09-16T07:28:52Z Joining on Multiple fields https://community.qlik.com/t5/QlikView/Joining-on-Multiple-fields/m-p/705814#M254454 <HTML><HEAD></HEAD><BODY><P>If there is no specific primary key in two tables and we need to join on more that one fields how that scenario can be handled?</P><P>What is the proper way of data modeling in such case.</P></BODY></HTML> Tue, 16 Sep 2014 07:24:09 GMT https://community.qlik.com/t5/QlikView/Joining-on-Multiple-fields/m-p/705814#M254454 rsdhavle 2014-09-16T07:24:09Z Re: Joining on Multiple fields https://community.qlik.com/t5/QlikView/Joining-on-Multiple-fields/m-p/705815#M254455 <HTML><HEAD></HEAD><BODY><P>you need to identify key columns (aka composite key) in both tables</P></BODY></HTML> Tue, 16 Sep 2014 07:28:52 GMT https://community.qlik.com/t5/QlikView/Joining-on-Multiple-fields/m-p/705815#M254455 Anonymous 2014-09-16T07:28:52Z Re: Joining on Multiple fields https://community.qlik.com/t5/QlikView/Joining-on-Multiple-fields/m-p/705816#M254456 <HTML><HEAD></HEAD><BODY><P>Can you provide little example on your requirement?</P><P>Joining of more than one field can be done by</P><P></P><P>Field1 &amp; '|' &amp; Field2 &amp; '|' &amp; Field3&nbsp; as %Key</P></BODY></HTML> Tue, 16 Sep 2014 07:29:31 GMT https://community.qlik.com/t5/QlikView/Joining-on-Multiple-fields/m-p/705816#M254456 MK_QSL 2014-09-16T07:29:31Z