topic autonumber keys in QlikView https://community.qlik.com/t5/QlikView/autonumber-keys/m-p/1250338#M851828 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>My key fields in the data model is based on string values(instead of number). I want to use autonumber to improve the performance.</P><P>Table1, Table2, and Table3 are connected using single key field. So i want to autonumber like below-<BR />autonumber(field1,'key1') as key //to be used in table1<BR />autonumber(field13,'key1') as key //to be used in table2<BR />autonumber(field25,'key1') as key //to be used in table3</P><P>Am I correct in doing like above??</P><P></P><P>I hope the 2nd parameter is not mandatory, unless I use autonumber for any other keys. Am I right??</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155569_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Please help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT surajap123 2020-11-25T16:16:04Z autonumber keys https://community.qlik.com/t5/QlikView/autonumber-keys/m-p/1250338#M851828 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>My key fields in the data model is based on string values(instead of number). I want to use autonumber to improve the performance.</P><P>Table1, Table2, and Table3 are connected using single key field. So i want to autonumber like below-<BR />autonumber(field1,'key1') as key //to be used in table1<BR />autonumber(field13,'key1') as key //to be used in table2<BR />autonumber(field25,'key1') as key //to be used in table3</P><P>Am I correct in doing like above??</P><P></P><P>I hope the 2nd parameter is not mandatory, unless I use autonumber for any other keys. Am I right??</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155569_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Please help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/autonumber-keys/m-p/1250338#M851828 surajap123 2020-11-25T16:16:04Z