Skip to Content
0
Former Member
Mar 02, 2009 at 10:08 AM

Split-Reverse Pivot

14 Views

Hi All

I have one question.

I have source file in XML format which contains data :

<Industry_Sector>Z;A;D;F;G</Industry_Sector>

my need is to upload data as Industry Sectors

Z

A

D

F

G

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?

Thanks

Himanshu Nijhawan