Combining two source fields in Import Manager

[Former Member]

Hi,

I am trying to combine two source fields say fld1 with 5 digit and Fld2 with 3 digit so that combined fld3 of 8 digit can be mapped to a 8 digit field in destination MDM side.

Any suggestion how to do this is highly appreciated

Thanks,

-reo

[former_member205403 · Accepted solution]

Hi Reo,

I am just adding details to how to combine fields in the import manager.

To combine two or more existing partitions for a destination node steps are as follows:

<b>1. </b>In the appropriate source hierarchy tree, select the node whose partitions you want to combine.

<b>2.</b> click on the Partition Field/Value tab to make it the active tab.

<b>3.</b> In the appropriate Partition list, select the two or more partition items you want to combine into a single partition.

<b>4.</b> Click on the Combine button, or right-click on one of the items and choose Combine Partitions from the context menu.

<b>5.</b> MDM combines the selected partition items.

<b>6.</b> Now you can map this partition directly to the destination field.

But as ur requirement seems ,u do not need to set delimiter.

Hope it will help you and let me know the results. please remark .

Thanks,

<b>Shiv Prashant Dixit</b>

[Former Member]

My reqmnt changed

[Former Member]

Reo,

If you need to also to store the 2 combining fields in MDM you can create a third field to store the combined vlaued. In the repository create a field, set the calculated property for the field and then set to calculation to concatenate the 2 "source" field values.

Regards

Con

[Former Member]

Use Partition Combine Option of the Import Manager.

Do not use any delimiter for the Partiion Combine option.

Hope this helps