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.