topic Re: Unique numeric key for several fields in different loads in QlikView https://community.qlik.com/t5/QlikView/Unique-numeric-key-for-several-fields-in-different-loads/m-p/52020#M8638 <HTML><HEAD></HEAD><BODY><P>Maybe you could use an approach like this one: <A href="https://community.qlik.com/message/1122515">Re: Convert concatenated numbers to num</A></P><P></P><P>- Marcus</P></BODY></HTML> Wed, 18 Apr 2018 13:22:24 GMT marcus_sommer 2018-04-18T13:22:24Z Unique numeric key for several fields in different loads https://community.qlik.com/t5/QlikView/Unique-numeric-key-for-several-fields-in-different-loads/m-p/52019#M8637 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>As I understand the functions of the autonumber (+ hash***) correctly create a numeric key only within a single load, because it depends on the sorting of the data and the order of reading from the table. <A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/CounterFunctions/autonumberhash256.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/CounterFunctions/autonumberhash256.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/CounterFunctions/autonumberhash256…</A></P><P></P><P>For a unique key in different downloads, you need to use the hash function without an <SPAN style="font-size: 13.3333px;">autonumber (hash)</SPAN><SPAN style="font-size: 10pt;">. But then you get a string of 43 characters, mostly in terms of the amount of data it's much worse than just concatenating several fields.</SPAN></P><P></P><P>Are there other ways to make a compact unique numeric key <STRONG style="text-decoration: underline;">in different </STRONG><SPAN style="font-size: 13.3333px;"><STRONG style="text-decoration: underline;">loads</STRONG></SPAN>?</P></BODY></HTML> Wed, 18 Apr 2018 00:51:02 GMT https://community.qlik.com/t5/QlikView/Unique-numeric-key-for-several-fields-in-different-loads/m-p/52019#M8637 warfollowmy_ver 2018-04-18T00:51:02Z Re: Unique numeric key for several fields in different loads https://community.qlik.com/t5/QlikView/Unique-numeric-key-for-several-fields-in-different-loads/m-p/52020#M8638 <HTML><HEAD></HEAD><BODY><P>Maybe you could use an approach like this one: <A href="https://community.qlik.com/message/1122515">Re: Convert concatenated numbers to num</A></P><P></P><P>- Marcus</P></BODY></HTML> Wed, 18 Apr 2018 13:22:24 GMT https://community.qlik.com/t5/QlikView/Unique-numeric-key-for-several-fields-in-different-loads/m-p/52020#M8638 marcus_sommer 2018-04-18T13:22:24Z