topic md5 hash, or something similar in QlikView https://community.qlik.com/t5/QlikView/md5-hash-or-something-similar/m-p/809299#M285631 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can anyone suggest a simple method to create a hash key field in a load script without using a QlikView hash function?&nbsp; I need to create a key that is constant, which will not change if the load order changes or data is inserted, so I can't use autonumber().&nbsp; The keys generated are going to be stored in a SQL database, so I can't use hash128(), as the quotes and commas make querying the field tricky.</P><P></P><P>Something that turns a string of text fields into a numeric key, or something like an md5 hash key would be ideal.</P><P></P><P>I'm probably missing something simple...&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks</P></BODY></HTML> Mon, 16 Mar 2015 11:49:01 GMT colinh 2015-03-16T11:49:01Z md5 hash, or something similar https://community.qlik.com/t5/QlikView/md5-hash-or-something-similar/m-p/809299#M285631 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can anyone suggest a simple method to create a hash key field in a load script without using a QlikView hash function?&nbsp; I need to create a key that is constant, which will not change if the load order changes or data is inserted, so I can't use autonumber().&nbsp; The keys generated are going to be stored in a SQL database, so I can't use hash128(), as the quotes and commas make querying the field tricky.</P><P></P><P>Something that turns a string of text fields into a numeric key, or something like an md5 hash key would be ideal.</P><P></P><P>I'm probably missing something simple...&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks</P></BODY></HTML> Mon, 16 Mar 2015 11:49:01 GMT https://community.qlik.com/t5/QlikView/md5-hash-or-something-similar/m-p/809299#M285631 colinh 2015-03-16T11:49:01Z