Configuration option confused

[Former Member]

Could anyone tell me in which case we use Split Hierarchy, Split Multiple Fields and Partition Combine and Multi-Valued, Coupled Numeric. The best way give me an example for each part. Thank you.

Alfred

[Former Member · Accepted solution]

Alfred,

Do you have the Import Manager reference guide? This should help further explain these options and when/where to use them. You can find it under the reference documentation for MDM 5.5.

<a href="https://websmp110.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_HIER_KEY=701100035871000358192&_OBJECT=011000358700004121872006E&">MDM 5.5 Documentation</a>

Thanks,

Tim

[Former Member]

Hi Almini,

<b><u>Split Hierarchy</u></b>

We use <b>Split Hierarchy</b> whenever we want to import the data in the form of hierarchies in the MDM repository. Like if we have data:

Printer;Inkjet

Printer;Dot Matrix

Printer;Laser

And you want to store it in a hierarchyhaving parent node as Printer and child Nodes as inkjet, Dot matrix and Laser.

Then first you will set split Delimiter as <b>;</b> because we have used semicolon in our input file and then after selecting delimiter, go to Split into Hierarchy. It will create a new field having the hierarchy. Thn simply map that field with the destination hierarchy table.

<u><b>Split Multiple Field</b></u>

In Split Multiple Field you can split the input data into multiple fields depending upon the delimiter that you have set. Like if you have excel file that contains names e.g. Almini Sanbra. Now you want to store First name and last name seperately in the MDM repository. Then in such situation you will use Split Multiple Field option. First you will have to set Split Delimiter just like Split Hierarchy. Then select split into multiple field. Suppose if you have set " " (space) as a delimiter, now wherever the MDM server will find space it will split into another field. Like in this example it will split Almini and Sanbra in two different fields. Now just map those newly created fields with the MDM repository fields.

<u><b>Partition Combine</b></u>

This functionality is used whenever you want to merge to different fields. Like in input file if you have first name and last name in two different fields and now you want to save first and last name in single field in MDM repository for that you will use Partition Combine. For this first of all go to Partition Field/Value Tab. then from the source hierarchy select that field to which you want to combine the field. Now in the source partition add that field which you want to combine to the "partition by" window.

<u><b>MultiValued Delimiter</b></u>

MDM identifies the individual delimited values within a sngle field when mapping to a Multi Valued field using the Multi Valued delimiter string.

Hope this should help you...

please feel free to revert to me for further claifications..

thanks

Varun Agarwal