How to add primary key on data table?
1.Open excel server template.
2.Right click, choose "Create Data Table":

3.Click the table name to add primary key in "Defined Data Tables" , and click the "PK" of the column or columns as primary key.

4.Click "Update Field".
5.Click "Exit".