Mapping doubt

[Former Member]

Hi

I have a mapping field. Source has a field ABC and target has a field XYZ.

If ABC= 006, then A, elseif ABC= 002 or 003 or 004 then M, else if ABC = 005 then D.

I guess we need to use the Boolean function " if then else " I am not able to get it right.

Can someone help me with the mapping

Regards

[former_member181962 · Accepted solution]

Use FixedValues function.

Maintain the Name- value pairs as follows

Name-Value

006-A

002-M

003-M

004-M

005-D

Pass input as your ABC field and output as XYZ field.

Regards,

ravi

[Former Member · Accepted solution]

Ravi,

Thanks, is it possible with the if then else function ?

[former_member200962 · Accepted solution]

>

> Ravi,
> 
> Thanks, is it possible with the if then else function ?

Yes, but why have a large number of If-Else combinations in your mapping logic when same can be achieved using a fixed-value mapping.

[Former Member · Accepted solution]

Thanks Ravi

It worked perfectly

Thanks Raja for offering help with UDF.

[sunilchandra007]

Just to add with Ravi, it is not possible to have same value for different key. Check out .

Regards,

Sunil Chandra

[balaji_pichaimuthu]

Hi,

As Ravi said use fixedvalue function , u can find this function under conversation functions.. drag this to mapping area ,, double click it. give the key and value as ravi mentioned.. choose " USE Key" option as "behaviour if lookup fails".

so mapping will look like

Abc> fixedvalue->xyz

regards,

Balaji

[rajasekhar_reddy14]

Hi Aijith,

Ravi already proposed one ption to achieve your requirement try with that,it is very easy.

other option is writing smal UDF it will work.

if you want UDF code let me know,but first try ravi option.

Regards,

Raj