I have one question.
I have source file in XML format which contains data :
my need is to upload data as Industry Sectors
I need to map it to the field Industry Sectors in MDM.
I followed steps :- 1) Split into multiple fields with ; as delimeter on the source side of import manager.
2) Selected all split fields and did reverse pivtoing.
When i tried with XML file its hows error "Unable to Create Reverse Pivot"
while when i tried with access i was able to do.
What may the error? or there is any other improve process that i can follow?