cancel
Showing results for 
Search instead for 
Did you mean: 

Check values of source field

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member189354
Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

Regards

Pothana

Former Member
0 Kudos

go for fix value mapping...

Former Member
0 Kudos

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

stefan_grube
Active Contributor
0 Kudos

> 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?