topic Re: Adding a unique identifier field to dataset in QlikView https://community.qlik.com/t5/QlikView/Adding-a-unique-identifier-field-to-dataset/m-p/968198#M964167 <HTML><HEAD></HEAD><BODY><P>Use the load on load function to load an additionall field to an existing table.</P><P></P><P>However, Is this key a new field or is it derived from the data set (the 12.5 mio rows)?</P></BODY></HTML> Tue, 13 Oct 2015 13:01:02 GMT Michiel_QV_Fan 2015-10-13T13:01:02Z Adding a unique identifier field to dataset https://community.qlik.com/t5/QlikView/Adding-a-unique-identifier-field-to-dataset/m-p/968196#M964165 <HTML><HEAD></HEAD><BODY><P>Hi, hoping someone can help. I have a very large dataset (12.5 million rows) and I'm looking to add a new field as a unique identifier/primary key. Due to the size, I'm having trouble opening it with Excel. I've already got it hooked up to a QV dashboard and I'm just wondering whether there is anyway to add this new identifier field within the script?</P><P></P><P>Any help would be much appreciated.</P><P></P><P>Matt</P></BODY></HTML> Tue, 13 Oct 2015 12:58:08 GMT https://community.qlik.com/t5/QlikView/Adding-a-unique-identifier-field-to-dataset/m-p/968196#M964165 mattphillip 2015-10-13T12:58:08Z Re: Adding a unique identifier field to dataset https://community.qlik.com/t5/QlikView/Adding-a-unique-identifier-field-to-dataset/m-p/968197#M964166 <HTML><HEAD></HEAD><BODY><P>You can try to add <STRONG>RowNo() as UniqueKey</STRONG></P></BODY></HTML> Tue, 13 Oct 2015 13:00:18 GMT https://community.qlik.com/t5/QlikView/Adding-a-unique-identifier-field-to-dataset/m-p/968197#M964166 sunny_talwar 2015-10-13T13:00:18Z Re: Adding a unique identifier field to dataset https://community.qlik.com/t5/QlikView/Adding-a-unique-identifier-field-to-dataset/m-p/968198#M964167 <HTML><HEAD></HEAD><BODY><P>Use the load on load function to load an additionall field to an existing table.</P><P></P><P>However, Is this key a new field or is it derived from the data set (the 12.5 mio rows)?</P></BODY></HTML> Tue, 13 Oct 2015 13:01:02 GMT https://community.qlik.com/t5/QlikView/Adding-a-unique-identifier-field-to-dataset/m-p/968198#M964167 Michiel_QV_Fan 2015-10-13T13:01:02Z Re: Adding a unique identifier field to dataset https://community.qlik.com/t5/QlikView/Adding-a-unique-identifier-field-to-dataset/m-p/968199#M964168 <HTML><HEAD></HEAD><BODY><P>Its a new field to hold any kind of unique value.</P></BODY></HTML> Tue, 13 Oct 2015 13:03:12 GMT https://community.qlik.com/t5/QlikView/Adding-a-unique-identifier-field-to-dataset/m-p/968199#M964168 mattphillip 2015-10-13T13:03:12Z