question

dkoger avatar image
dkoger asked

The Master Data Services add-in for Excel corrupted the data when I used a calculation on the load. Is there a way to avoid this?

I have a Excel Sheet that connects to the data source. The data source has [title], [FirstName], [MiddleName], [LastName] and [Suffix]. I concatenate them into a single column called [Full Name]. When I ran the create entity I generated the code automatically and assigned the name to [Full Name]. The name in the entity does not match the [Full Name] in the Excel sheet. In fact it is off by one row. e.g. Smith, Adam is followed by Buzzy, Ruth A. but the full name for Buzzy, Ruth A. is Smith, Adam in the Master Data Services entity. My guess is Master Data Services does not support calculations as part of the Create Entity process.
master-data-services
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.