Unable to get target field

[Former Member]

HI

I have a mapping field. I have a field XYZ in the source. It's mapped to ABC in target. If XYZ doesn't exist then ABC = 001. If XYZ exists and if its values are 1, 2 or 3, then ABC = 003

How to meet this requirement ?

[Former Member · Accepted solution]

XYZ - MapWithDefault(001)-FixValues(1,2,3 - 003) -> ABC

or

XYZ-FixValues(1-003, 2-003,3-003 and default 001) -> ABC

standard function "FixValues" is available in Conversions category.

Venkat.

Edited by: Venkat Anusuri on May 13, 2010 10:56 AM

[Former Member · Accepted solution]

It works for the second condition. But when XYZ doesn't exist, it doesn't give the value 001. Mapwithdefault doesn't work

[Former Member · Accepted solution]

Hi

use the second condition.. with Mapwithdefault function

XYZ--> MapwithDefault->FixValues(1-003, 2-003,3-003 and default 001) -> ABC

Regards

Ramg

[Former Member · Accepted solution]

do it like this

if exists (xyz) & xyz = 1 or xyz = 2 or xyz = 3

abc = 003

else

abc = 001

you can easily do it using standard functions or if you prefer you can do udf

code is almost there in the above lines i have written.

Edited by: mimranacc on May 14, 2010 7:54 AM

[balaji_pichaimuthu · Accepted solution]

use if then else condition.. If xyz> exist function->... then use fix values else assign with the constant 001. then assign the output of the if else then part to target field.. it will work..

Regards,

balaji

[Former Member]

if XYX exists then use FixValues function and there you can give you fix values input and output Else give the constant value to the output.

Regards,

NJ