This content has been marked as final.
Show 4 replies
-
1. Re: Add primary key to view from Designer
rareddy Jan 12, 2018 3:13 PM (in response to dvallabh_doi)First, create a new column on the view say "id" and in the transformation use "row_number()" function to generate the unique ids, then add PrimaryKey and select the "id" column you created as the column to create the Primary Key on.
-
2. Re: Add primary key to view from Designer
dvallabh_doi Jan 12, 2018 3:28 PM (in response to rareddy) -
3. Re: Add primary key to view from Designer
rareddy Jan 12, 2018 5:28 PM (in response to dvallabh_doi)Try adding transformation for the View first, I believe the option then shows up (hopefully)
-
4. Re: Add primary key to view from Designer
dvallabh_doi Jan 17, 2018 2:39 PM (in response to rareddy)