New primary key definition is invalid due to duplicate entries

[JABS]

Hello SAP.

I am new to datasphere and trying to figure it out.

I am trying to set up an intelligent lookup as illustrated from this link: Data Marketplace and Intelligent Lookup – Part 1 (sap.com) at around 11 min. 25. sec.

I am unable to insert SalesByCityView due to entity not having any primary keys. In the link provided, it does not seem that the instructor have used priamry keys in sales_by_city at around 3 min. 54 sec.

Then, when i am trying to change set a new key in e.g. JABS_test_addresses looks like this:

 

with the following error: new primary key definition is invalid due to duplicate entries. Tried removing all primary keys and then i am able to deploy the views or tables just fine. Though when I am trying to set a new primary key, the same error comes.

Could you please assist in, thoroughly pinpoint where the duplicate entry happens? And how can I fix it? Is it due to circular referencing between dependent objects?

Kind regards, 

Jannik

SAP Datasphere

[JABS]

Sorted by setting ADDRESSID to primary key and project it onto view just to validate.

[Martin_Kuma]

Hi Jabs, Try to specify the pairing column as CITY.