Split-Reverse Pivot

[Former Member]

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

[Former Member]

ok

[Former Member]

Hi Himanshu,

As far as i know XML is an updateable data source,so it should allow you to modify the data source.

Pivoting and Reverse pivoting are the options in MDM that need to work with an Updateable data source only.

Please check the READ ONLY option .This option will be checked by default for an XML source.It should be unchecked for updating the XML source file.

You can refer the below links to understand better how Pivoting and Reverse pivoting works in MDM:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0a9cee4-9cd1-2a10-62b6-ea2acb06...

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0a9cee4-9cd1-2a10-62b6-ea2acb06...

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

Hi

You are right that XML is a updatable data source thats why i asked that i am not able to do with XML while from access its possible. I have seen read only option, its "unchecked" while opening import manager.

Take the eg of source data:-

<?xml version="1.0" encoding="UTF-8"?>

<EVO_Material>

<Products>

<Material_Number>000010388765</Material_Number>

<Industry_Sector>a;b;c;d</Industry_Sector>

</Products>

</EVO_Material>

Thanks

Himanshu

[Former Member]

Hello Himanshu,

If I am not mistaken, the industry sector field is a flat look up multivalued field in the Main table which is looking upon a flat table "Industry Sector",

If this is your scenario, then you need not do Pivot and split at all. What you need to do is...

1. RIght click on the industry sector field and Set Field Mappinf Delimiter = Multi-valued (

2. Map the field

3. Then in the value Mapping Frame, either select the values one by one on Destinatioon side and map values or Just click "Add".

This should MAP existing values or Add New values for all the industry sector values namely a, b, c and d to the product number 000010388765 as per your example.

Let me know if you have further questions. Please update with your results.

Thanks

Shai

[Former Member]

Hi,

If I am not mistaken, the industry sector field is a flat look up multivalued field in the Main table which is looking upon a flat table "Industry Sector

Thanks for your reply. It was just an e.g. in which i showed source data.

Lets take another simple one

Name to be mapped with NAME1

Tim;Jack -

---

XY;AB -

---

Here i am mapping source field Name to Destination field NAME1

I need to split name as -- Name -

---

NAME1

Tim

Jack

XY

AB

This thing i am able to do with Access but not with XML.

Thanks

Himanshu

[Former Member]

Hi Himanshu,

The prerequistie to create a pivot and a reverse pivot is that the data source must be updateable.

So it wouldnt work with XML.

Hope it helps.

Thanks,

Minaz