topic Re: Need Information on Autonumberhash128 in QlikView https://community.qlik.com/t5/QlikView/Need-Information-on-Autonumberhash128/m-p/94954#M757063 <HTML><HEAD></HEAD><BODY><P>If you join the tables, there is no need to create a composite key for the join.&nbsp; Instead join using column A and Column B.</P><P></P><P>-Rob</P></BODY></HTML> Fri, 21 Sep 2018 15:47:11 GMT rwunderlich 2018-09-21T15:47:11Z Need Information on Autonumberhash128 https://community.qlik.com/t5/QlikView/Need-Information-on-Autonumberhash128/m-p/94953#M757062 <HTML><HEAD></HEAD><BODY><P>Hi team,</P><P></P><P>I have created a composite key (%key) using autonumberhash128 in two tables using same fields.&nbsp; Is it preferable to use this %key for joining two tables. like below</P><P>eg:</P><P></P><P>tab1:</P><P>load *,</P><P>Autonumberhash128(column A &amp; column b) as %Key</P><P>from table1</P><P></P><P>LEFT JOIN(tab1)</P><P></P><P>tab2:</P><P style="font-size: 13.3333px;">load *,</P><P style="font-size: 13.3333px;">Autonumberhash128(column A &amp; column b) as %Key</P><P style="font-size: 13.3333px;">from table2</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-Information-on-Autonumberhash128/m-p/94953#M757062 nagarajuabhi 2020-11-25T16:16:04Z Re: Need Information on Autonumberhash128 https://community.qlik.com/t5/QlikView/Need-Information-on-Autonumberhash128/m-p/94954#M757063 <HTML><HEAD></HEAD><BODY><P>If you join the tables, there is no need to create a composite key for the join.&nbsp; Instead join using column A and Column B.</P><P></P><P>-Rob</P></BODY></HTML> Fri, 21 Sep 2018 15:47:11 GMT https://community.qlik.com/t5/QlikView/Need-Information-on-Autonumberhash128/m-p/94954#M757063 rwunderlich 2018-09-21T15:47:11Z Re: Need Information on Autonumberhash128 https://community.qlik.com/t5/QlikView/Need-Information-on-Autonumberhash128/m-p/94955#M757064 <HTML><HEAD></HEAD><BODY><P>If you need to join tables in two columns, A and B.. it depends on the amount of data i guess, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Autonumberhash128 can optimise your application.</SPAN></P></BODY></HTML> Fri, 21 Sep 2018 16:16:29 GMT https://community.qlik.com/t5/QlikView/Need-Information-on-Autonumberhash128/m-p/94955#M757064 shiveshsingh 2018-09-21T16:16:29Z