Check values of source field

[Former Member]

In mapping i need to check the value of source field and then map accordingly to target.

Lets say the source field is customer number, i have around 100 or 200 customer numbers which should be mapped to target.

If any other customer number comes which is not in the list it should not be mapped to target.

What is best way to handle this mapping.

[former_member189354]

Hi,

Better to go for Valu maping where your customer number let's say 100 customer number will be sepeated by some delimeter in the target side like 111#123#1234..../At point of time it will return 100 cust number to a UDF where at runtime you will check if the value is present or not if not means go for returing the own key

Thank you,

Mallikarjuna Rao M

[former_member472138]

Are these customers are serially alligned or random numbers? Bcaz, You can go ahead with small UDF.

Regards

Pothana

[Former Member]

go for fix value mapping...

[Former Member]

I am looking for a optimized solution rather than fix values and value mapping.

[stefan_grube]

> I am looking for a optimized solution rather than fix values and value mapping.

Value mapping is just made for this.

I wonder what optimized solution you imagine?