Marusya_lam
New Member
- Joined
- Dec 8, 2014
- Messages
- 2
Hi all, good day!
Thre are 2 tables exported in PowerPivot. For convenience it's SAP delivery with Names of products (from different Distributors) - "table 1" - and master-sdata table with matching Russian names of products/English names of prosducts - "table 2". So I want to make connection in PP between Names (table 1) and Russian names of Products (table 2). But I see error - [FONT=open_sans]"The relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values". I checked 10 times in Excel (and also in MS Access making data model. The list of Russian mnames of products form tabble 2 is unique (I also TRIMed it in Excel JIC. Maybe somebody faced with the same problem?
Thanks in advance.
Maria[/FONT]
Thre are 2 tables exported in PowerPivot. For convenience it's SAP delivery with Names of products (from different Distributors) - "table 1" - and master-sdata table with matching Russian names of products/English names of prosducts - "table 2". So I want to make connection in PP between Names (table 1) and Russian names of Products (table 2). But I see error - [FONT=open_sans]"The relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values". I checked 10 times in Excel (and also in MS Access making data model. The list of Russian mnames of products form tabble 2 is unique (I also TRIMed it in Excel JIC. Maybe somebody faced with the same problem?
Thanks in advance.
Maria[/FONT]