topic Using autoNumberHash in QlikView https://community.qlik.com/t5/QlikView/Using-autoNumberHash/m-p/161147#M35149 <HTML><HEAD></HEAD><BODY><P>Hi, You do it using preceding load as shown below. As it is not a SQL function, you are getting an error.</P><P>Load autonumberhash128(DRIVER.......) as driverPK,*;</P><P>SQL SELECT DRIVER.REGION_ID,DRIVER.ID......</P><P>From MyTable.</P><P></P></BODY></HTML> Fri, 26 Feb 2010 13:01:13 GMT vidyut 2010-02-26T13:01:13Z Using autoNumberHash https://community.qlik.com/t5/QlikView/Using-autoNumberHash/m-p/161146#M35148 <HTML><HEAD></HEAD><BODY><P>Hello Guys!</P><P>I'm creating my first QV document and I have a lot of composite keys in my database...</P><P>So, I'm wondering to do something like:</P><P>SQL SELECT autonumberhash128 ( DRIVER.REGION_ID, DRIVER.ID ) as "driverPK",<BR /><BR /> DRIVER.REGION_ID,<BR /> DRIVER.ID,<BR /> FIRST_NAME<BR />FROM myTable;</P><P>I'm importing data from SQL Server database, and of course, autoNumberHash128 is not a SQL Server function. How it's works?</P><P>QV throws an error when I tried to run this query.</P><P>There is any specific manual regarding load data and scripts?</P><P>Regards,</P><P>RM</P></BODY></HTML> Fri, 26 Feb 2010 11:43:12 GMT https://community.qlik.com/t5/QlikView/Using-autoNumberHash/m-p/161146#M35148 2010-02-26T11:43:12Z Using autoNumberHash https://community.qlik.com/t5/QlikView/Using-autoNumberHash/m-p/161147#M35149 <HTML><HEAD></HEAD><BODY><P>Hi, You do it using preceding load as shown below. As it is not a SQL function, you are getting an error.</P><P>Load autonumberhash128(DRIVER.......) as driverPK,*;</P><P>SQL SELECT DRIVER.REGION_ID,DRIVER.ID......</P><P>From MyTable.</P><P></P></BODY></HTML> Fri, 26 Feb 2010 13:01:13 GMT https://community.qlik.com/t5/QlikView/Using-autoNumberHash/m-p/161147#M35149 vidyut 2010-02-26T13:01:13Z