none
MDS Excel add-in: combine data does not work

    Question

  • Hi there,

    I'm sure I'm just missing something very minor or maybe the Excel add-in does not work perfectly on Windows XP...

    I would like to use the COMBINE DATA functionality. I did exactly as per this guide: http://technet.microsoft.com/en-us/library/hh548680.aspx

    I list the steps I do first then describe what I expect to happen and what happens:

    • From an Excel table I created an MDS entity, straightforward.
    • Then I put another column next to the existing table/entity
    • FYI: Code field is set to be populated automatically
    • I highlighter the full table (including Name and Code columns, too + the new column)
    • I clicked on COMBINE DATA
    • I made sure the Range to combine with MDS data has the correct range
    • Excel was smart enough to correctly identify the Entity columns and Corresponding columns, including the new one
    • I unmapped code since it will be populated automatically!
    • new rows appeared at the bottom of the table highlighted as new ones and a new SOURCE column is available
    • I click publish and everything looks OK
    • but when I reopen the entity no new column is there but the new rows are still present.

    I have MDS admin access.

    Is there something I'm missing? I tried to look for videos, tutorials but the same info is mentioned everywhere because as far as I think this should be it.

    Any help/idea would be greatly appreciated! Please let me know if any more detail is needed I accidentally forgot to put into the question.

    Thanks,

    MartinIsti

    Thursday, August 22, 2013 2:41 AM