on 09-20-2012 3:40 PM
SAP MDM 7.1 Import Manager documentation states:
"Not only can each individual source value be manually edited, built-in and custom-designed value conversion filters can automatically convert or reformat a single value or the entire set of distinct values with a single command".
I can't see anywhere in the documentation how to create your own conversion filter. Can anybody please advise?
BR,
Tony.
Hi Anthony,
As mentioned in the other post this achieved through Value Conversion Filters in Import Manager.
A use case of this is discussed in the following blog -
Please let me know in case you need further details.
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi and Ankush,
Thanks for the replies; although there are various options, there is no way (at least as far as I can see) to create your own specific filter.
I have a requirement to remove leading zeroes from material numbers, but I cannot see a way to do that using the portfolio of functions provided.
BR,
Tony.
Hi Anthony,
You can use option of "Replace" under "Set Value Conversion Filter". There you can enter leading zeroes and leave the second input box blank(see screenshot). This will remove all the leading zeroes from the Material Numbers. But you can tell us the requirement so that we can let you know if there is any other easier way to achieve your requirement. Thank you.
Thanks and Regards,
Ankush
Hi Tony,
If the number of Zeroes is variable, then you won't be able to perform such transformation in MDM system. You can do such transformation in PI system in case of Automatic imports or you do the same in Excel(for example) source file for Manual imports.
Another way could be that you can design MDM workflow which would run assignment to do the transformation after the import(If you are able to import data without doing transformations prior to import). You would require to assign Workflow to Import map so that it is automatically triggered after the import is completed and also assignment expression needs to be written to achieve desired result.
You can choose any option as per your requirement and ease of implementation in your system.
Please let us know in case of any doubts. Thank you.
Regards,
Ankush
Hi Anthony,
You can have another field which is of type integer,map that to material number clone in import manager.
This way all leading zeroes will be removed.
Now you can either use integer field like in case of portal search ivew and run assignment based on condtions as mentioned in the above post to achieve desired state.
Thanks,
Ravi
Hi Tony,
When you map source fields with DestinaStion fields, you need to right click on ource field and there you can see the "Set Value Conversion Filter". There are various options inside that menu option and you can use them as desired.
Please let me know if you have more doubts.
Thanks and Regards,
Ankush
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.