Hello... I'm hoping to get some help on a mapping needed for Product. There are two sets of Products (standard & non-standard). Within the Source system the length of product IDs are limited to 7. I would like to create a mapping that says any source product (UD3) that is greater than the length of 7... Target NON_STD.
Is there a way to create a script for this mapping requirement? I prefer to not create 1000s of Explicit maps for the non-standard Products. They have no clear pattern, only that they are usually over 7 digits. Thanks.