topic Generate same key in different tables based on 2 fields in QlikView https://community.qlik.com/t5/QlikView/Generate-same-key-in-different-tables-based-on-2-fields/m-p/556391#M689617 <HTML><HEAD></HEAD><BODY><P>Table1 has fields T1.FieldA, T1.FieldB, Count1</P><P>Table2 has fields T2.FieldA, T2.FieldB, Count2</P><P></P><P>I need to keep the tables separate because I don't want the counts to inflate, but how do I join the two tables on fields A and B?</P><P></P><P>I could create a link table, but I would prefer to make a compound key.&nbsp; Since one of these fields is text, I was wondering if there is some function that will translate the combined FieldA+FieldB to the exact same integer in both tables.</P><P></P><P>Thank you</P></BODY></HTML> Thu, 31 Oct 2013 15:29:22 GMT 2013-10-31T15:29:22Z Generate same key in different tables based on 2 fields https://community.qlik.com/t5/QlikView/Generate-same-key-in-different-tables-based-on-2-fields/m-p/556391#M689617 <HTML><HEAD></HEAD><BODY><P>Table1 has fields T1.FieldA, T1.FieldB, Count1</P><P>Table2 has fields T2.FieldA, T2.FieldB, Count2</P><P></P><P>I need to keep the tables separate because I don't want the counts to inflate, but how do I join the two tables on fields A and B?</P><P></P><P>I could create a link table, but I would prefer to make a compound key.&nbsp; Since one of these fields is text, I was wondering if there is some function that will translate the combined FieldA+FieldB to the exact same integer in both tables.</P><P></P><P>Thank you</P></BODY></HTML> Thu, 31 Oct 2013 15:29:22 GMT https://community.qlik.com/t5/QlikView/Generate-same-key-in-different-tables-based-on-2-fields/m-p/556391#M689617 2013-10-31T15:29:22Z Re: Generate same key in different tables based on 2 fields https://community.qlik.com/t5/QlikView/Generate-same-key-in-different-tables-based-on-2-fields/m-p/556392#M689618 <HTML><HEAD></HEAD><BODY><P>Table1:</P><P>LOAD</P><P>autonumberhash128(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">T1.FieldA, T1.FieldB</SPAN>) as Key</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count1</SPAN></P><P></P><P>Table2:</P><P>LOAD</P><P>autonumberhash128(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">T2.FieldA, T2.FieldB</SPAN>) as Key</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count1</SPAN></P></BODY></HTML> Thu, 31 Oct 2013 15:36:50 GMT https://community.qlik.com/t5/QlikView/Generate-same-key-in-different-tables-based-on-2-fields/m-p/556392#M689618 Clever_Anjos 2013-10-31T15:36:50Z