cancel
Showing results for 
Search instead for 
Did you mean: 

Filter option in Matching Fields

Former Member
0 Kudos

Hi,

When right click on Matching fields, there is Filter in import Manager. Can anyone let me know, how that Filter related to Matching Fields records please?

Thanks.

Regards,

Lahari

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I need Filter option on Matching fields list. Please explain any one/

Edited by: Lahari on Jun 20, 2008 6:13 PM

Edited by: Lahari on Jun 20, 2008 6:14 PM

Former Member
0 Kudos

Hi Lahari,

Filtering narrows down both the source and destination record sets, but with slightly different effects, as follows:

Source Side i.e. In Match records tab narrows down the set of source records so that those that do not meet the filtering criteria can be excluded from the import.

Destination i.e. In matching fields tab narrows down the set of destination records, excluding those that do not meet the filtering criteria from record matching.

The filter is inclusive, and expands the set of records on which you can perform import operations to those that do meet the filtering criteria.

For more information please refer to the below link

[http://help.sap.com/saphelp_mdm550/helpdata/en/43/12036df94c3e92e10000000a1553f6/frameset.htm]

Go to Matching Records -> Records Matching Operations -> Setting the Record Filtering Criteria

Regards,

Jitesh Talreja

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Set Value Conversion Filter is useful for Normalizing Data. it has various functions. it also helpful in Parametric Import means if a field has 1000 of values then instead changing all the values if you use APPLY OPERATOR function like Append , Prepend and for Numeric field you can use operators +, -, * etc.

For example if your text field having 1000 values and u want US in front of all the values then use operator Prepend in Apply Operator by right clicking on that field --> Set Value Conversion Filter -->Apply Operator here use Operator Prepend and Operand2 = US then for that field all the values get converted by Prepend US . like there is value say A then converted value = USA, so in this way you dnt need to change all the values for Particular field in the source file.

Hope it will Help you,

Rewards if Useful.....

Mandeep Saini

Edited by: Mandeep Saini on Jun 20, 2008 5:14 PM