Hoping for some assistance when doing an update on a datavese table. Ive created a simple table, Ive added a column called Email and thats the only column Ive added. I want to test updating that column... I use the dataverse input tool to bring through all fields, I believe the field thats the same as the table name is the unique identifier column, so I select that, the name field and the Email field. I have a formula to create my email in the email column and Ive selected the table name field (CJTest), the Emil and the Name fields. In the Dataverse Output tool, I select my table, select the output option to be update and I at first selected the CJTest field as the Field containing the Primary Key but now when I go back into the Dataverse Output tool, I can see its greyed out and odt_ctjestid is the primary key field. Ive tried renaming the CJTest field to odt_cjtest and leaving it as CJTest but still get the same error: Unique Identifier Column not found Any ideas what Im doing wrong?
