1

Does anybody know how to avoid error "The relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values" in Excel Data model - data model consider idXYZ identical to idxyz

Especially salesforce.com uses case-sensitive IDs.

istee1
  • 21
  • 5
  • change your data model to make identifier unique regardless of case? – Forward Ed Sep 25 '17 at 12:00
  • @ForwardEd unfortunately I cannot change identifier. I am aware of 15/18 long identifiers in SFDC (18-chars-long are fine, but I have to use 15-long). Also I cannot make any concat colums (such as "ID"&"Name") – istee1 Sep 25 '17 at 12:55

0 Answers0