Import Manager Advanced Features

[Former Member]

Hi,

I want to discuss MDM Import Manager Advanced Features.

Cloning Fields: If we want to map a source field to 2 destination fileds, we will create a clone of the source field in Import Manager and map it to 2 different destination.

This can be done only if the source type is updateable.

Adding Fields: We can add to the source data an empty field with the single NULL value in its list of distinct values. For example, if the source data is missing a field for which all of the values would be the same, you can add a field, and then use the Map Fields/Values tab to map the single NULL value to the corresponding destination value.

Renaming field: All fields can be renamed, but usually it is preferable to keep the original name.

Joining a Table: A join combines information from the records in which two tables by using the values in a pair of matching fields to match records in the two tables.

Properties of Join: Transitive Joins: If Table A is joined to Table B and Table B is joined to Table C, then Table C is effectively joined to Table A.

Primary Matching Field: The matching field in the primary table. [Join] appended to the name of the primary matching field. Also added as the first child of the lookup matching field as [From: primary table, primary matching field]

Lookup Matching Field: The matching field in the lookup table. [join] appended to the name of the lookup matching field. Also added as the first child of the primary matching field as [From: lookup table, lookup matching field]

Lookup Field: Field looked up from the lookup table into the primary table. Added as child of the lookup table into the primary table.

Looking Up a Field: Pre-requisite: A Join relationship has been established between a primary and lookup table.

MDM Import Manager added a child node at the end of the primary table.

Create Look Up Fields: At system created Child node--> right mouse click & select "Lookup" --> choose field to be looked up --> repeat as necessary.

Parametric Import: Parametric Import lists the complete set of distinct values for each field in the source data. Changing a value as part of the import (by mapping or converting it) changes it in all of the underlying records that contain that value.

Value Conversion Filter (VCF) : Value Conversion Filters automate repetitive and error- prone transformations, eliminating manual typing and the possibility of user error.

The filters can be applied at:

Field level.

> Conversions are applied sequentially to each converted value that has not been individually edited or converted at the value level.

> Conversion starts with the original value.

Value level. The conversion is applied to the individual converted values.

Converted values result from:

> prior application of field-level filters.

> value-level filters.

> manual edits.

For each field, you can apply one or more value conversion filters at the field level. For each value, you can apply one or more value conversion filters at the individual value level(reagrdless of whether or not value mapping is required).

There is an option for Multiple-Step VCFs.

For example when we apply: "Apply Operator [Prepend "Before TEXT]"

Where to set the Operator?

I am also clear with Value Field Partition Concept.

Regards

Kaushik Banerjee

[Former Member · Accepted solution]

Hi Kaushik,

When you want to apply an operator to the converted source value.

- Select the Value in the Value mapping

- Rt Click- > Apply Operator

- It will by default take the selected value as the Operand 1

- Then you need to select whether you want to append or prepend the Operator

- Your operand 2 will be the operator you wish to prepend or append say(#) for eg

- So it will append or prepend # to your selected value.

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member · Accepted solution]

Hi,

This is the answer:

Apply Operatoru2026

Applies the numeric or string operator to the selected values:

· +

Add the specified value

· -

Subtract the specified value

· *

Multiply by the specified value

· /

Divide by the specified value

· Equals

Set to the specified value

· NULL Equals

Set to the specified value only if NULL

· Round

Round to the specified number of decimal places

· Ceiling

Ceiling to the specified number of decimal places

· Truncate

Truncate to the specified number of decimal places

· Prepend

Prepend the specified string

· Append

Append the specified string

· Truncate

Truncate the string to the specified width

Regards

Kaushik Banerjee

[Former Member · Accepted solution]

If we use prepend $, then we need to specify the $ operator , I need to know where to specify the $ operator?

Regards

Kaushik Banerjee

[Former Member · Accepted solution]

Hi Simona,

your answer is right. First Operator is the value which we select and operator 2 is the string we need to prepend.

Regards

Kaushik Banerjee

[Former Member]

It is solved now.

Regards

Kaushik Banerjee

[Former Member]

Hi Jitesh,

I just did the step.

You need to select the source field and right click on it Field Mapping (Map Field/Values). Then Operand1 is the source field telephone_no, Operator is prepend (eaxmple) and Operand2 is +44. This will prepend +44 before all phone nos.

Regards

Kaushik Banerjee

[Former Member]

Hi Kaushik,

You can either apply value conversion filters at the field level or at the value level.

The only difference is that if you apply your value conversion at the field level then the filter will be applicable to all the values under it.

At the value level you can apply different conversion for different values.

Applying single or multiple conversion filters will only allow you to either Append or Prepend certain operators to the converted values.

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

Hi Kaushik,

There are two operators:

1. Append

2. Prepend

Operand1 is fixed i.e. the current value of that field and you can insert the second operand i.e. any value you want to either append the current value or prepend it.

In many business scenarios it is required to make some value modifications either by appending something or prepending something.

E.g. your source has values for field Material as 1000,2000,3000, and so on and your requirement is to store these values in the form RK1000,RK2000,RK3000 and so on i.e. you want to prepend "RK" to the incoming values. In such cases instead of inserting the entire source data into the repository and then changing it, its better to change the values at the time of import only.

In order to apply the operator you first need to decide whether you want to append/prepend the operand for all the values or on particular fields.

If you want for all the values then map the desired field, right click on it, select Value Conversion Filter and Apply Operator...

Same path applies on the value

Regards,

Jitesh Talreja

[Former Member]

Hi Kaushik,

If you want to apply multiple value conversion filters in Import manager; please follow these steps:

1. Connect the file in import manager.

2. Go, to Map Fields/Value tab.

3. Select the field on whose values you want to perform multiple VCFs.

4. Map that field to the destination repository field.

5. You can perform multiple VCFs on the field level only, you can't perform this on any individual value.

6. After mapping that field, right click on it and select Set Value Conversion Filter --> Select Miltiple... --> Now click on add and add the VCF which you want to perform.

7. Similarly you can add multiple VCFs as well in the same window. Every new VCF will appear in new window. Now click on OK.

8. It will automatically perfomr all VCFs taht you defined in the window to all the values of that particular field.

Like this, you can add multiple VCFs to any particular source field in Import manager.

Regards,

Varun

[Former Member]

Hi Kaushik,

Where to apply the operator

Refer to the below link

http://help.sap.com/saphelp_mdmgds55/helpdata/EN/43/12036df94c3e92e10000000a1553f6/frameset.htm

Hope it helps.

Thanks,

Minaz