Display Field value matching

[Former Member]

Hi All,

One of the Sub table contains two fields as Display Fields : Name(Default) and Identity .

In Import manager I want Value Map the Identity field with One of the field in Source File.The problem is Map button is Disable for the Identity field but its enable for the Name Field?

While creating identity Field in the Repository Am i Missing Anything? How can i enable the map button for Identity Field?

[Former Member]

Hi Priya,

If I understood your problem, you want your hierarchy in taxonomy to look like as AA is your root node and 001, 002 are children.

If this is the case then a very simple solution for that can be formatting your source file itself with two columns (Name and Identity). Then you will need to split only identity based on your name and map "Name" with "Name in destination in "Map fields" tab.

Hope this solves your problem.

Regards,

Dheeraj.

[Former Member]

Hi Priya,

Is this problem resolved. I have the same issue in one of our projects?

Hi Mircea Precup,

I did not find any note on ther service market place talking about the fix. Can you please let me know if there is any note/resolution from SAP?

Regards,

Swamycharan.

[Former Member]

Hi Priya,

Whenever we have more than one display field, we need to create compound field before

proceeding to vaue mapping.

Here Name and Identity both are display fields.After you use split into hierarchy command for identity field , do field mapping.As soon as you complete field mapping , go for creating compound field.

To create compound field,

Right-click in the Source Hierarchy tree and choose Create Compound

Field from the context menu. MDM adds the compound field to the Source Hierarchy tree and to

the list of fields in the Source Fields grid.

The compound source field appears in the Source Field grid as “compound lookup field <source field

1; source field n>” (where “compound lookup field” is the name of a destination lookup field

and “source field n” is the name of the nth source field).

Hope it helps.

Thanks,

Narendra.M

[Former Member]

Hi Priya,

1. While splitting the Identity field into Hierarchy by using Split into Hirerarchy option, first set the delimiter using Set Split Delimiter -> Split Hierarchy and set it to "," in your case.

2. Whenever the table contains more than one display field then that fields will appear in the Import Manager as "D" in the column F/D/Q/A hope you are mapping the Name field with D Name and similarly identity field with D Identity.Then select both the fields in the Source Fields and right click and say Create Compound Field it will automatically create the compound field and map it with F Category<Name;Identity>

Regards,

Jitesh Talreja

[Former Member]

Hi Priya,

In the Console just set the Name and Identity fields as Display Fields and load the repository with Update Indices.No other configurations are required.

Create one temproary text file with 3 columns viz. Name, Identity and Test.Import this file using import manager and just check whether in this case it is allowing to map the Identity field or not.If it does then there is some data type problem in the source file that you are using currently.

Note: Dont use the existing map

Regards,

Jitesh Talreja

[Former Member]

Hi All,

Let me elaborate more...I have two Display fields in a Taxonomy table Name and Identity . In source file (.Xls) Identity field comes like this AA001,AA002,AA003,AA04 for this field i have to create a split hierarchy field, after that i have to map this split hierarchy field with Identity field.

The problem is I am unable to do value mapping to the split hierarchy field with identity ( Because i have to add split hierarchy field as Add as a branch) the map button is always disabled .How can i get that one?

Please let me know.

[Former Member]

Hi Priya,

I wrote a OSS to SAP for the same Problem.

Are you using MDM 5.5 SP06? If so, it is a bug, which should be solved with a Hotfix to the Support Package 2. This should come up soon (this week?).

BR,

Mircea

[Former Member]

Hi Priya,

If a field is already selected as a matching field under the matching tab in Import manger then it will not allow you to map/Unmap that field under the map tab.

If you are using an exsisting Map wherein <identity> field is already selected as the matching field then this may be the reason of the problem.

Follow these steps:

- Open import manger using the exsisting map.

- See if the <identity> field is available to map

- If not go to matching tab

- See if <identity> field is selected.If yes Remove.

- Go back to map tab

- See if its available for mapping.

I think this could b eone of the reason.

If it still does not solve the prob then try not using the saved map and try.

Hope it helps

Thanks

Simona

[Former Member]

Hi Priya,

One of the problem can be the Type of the Field- Identity.

If it is a calculated field, log field or any time stamp field, it will not allow you to Import. It should be a normal text or an integer field etc.

Hence kindly check that.

Hope it helps.

Thanks and Regards

Nitin Jain

[Former Member]

Its normal Text field.

[Former Member]

Hi Priya,

According to me when the current table is a lookup table, record matching is required against the display field as a matching field. When the lookup table has multiple display fields, the required record matching is to all of the display fields as a matching field combination.Thus you would be able to map name field as it would be the multiple matching field.

For more information this please go through following links:

[http://help.sap.com/saphelp_mdm550/helpdata/en/43/31fae3c3d3324ee10000000a422035/content.htm]

[http://help.sap.com/saphelp_mdm550/helpdata/en/43/46bba42d721800e10000000a1553f6/content.htm]

I hope I am able to solve your problem

Thanks & Regards

Dilmit Chadha

[Former Member]

My Current table is Taxonomy table.Name and identity are the fields in the taxonomy table.