Mapping Help for replacing source value

[sridharreddy_kondam]

Mapping Help for replacing source value

Posted: Mar 14, 2006 1:06 AM Reply

Hi all,

I am unable to do transform the source value to required target value,

From Source ADDRESS_TYPE = 'HOME' should be replaced with 03 to target field ANSSA, and 'MAIL' to be replaced with 05, I am trying to do it but i am unable to handle it, please give u r valuable suggestions,

The source structure is like this,

- <Event ID="239" TRANS_TYPE="ADR">

<PersAddr GEO_LOC_CD="US" EMPLID="29" ADDRESS_TYPE="HOME" EFFDT="02/15/2006" ADDRESS1="92nd Floor" ADDRESS2="812backstreet" ADDRESS3="" ADDRESS4="" CITY="London" COUNTY="" STATE="AN" POSTAL="EC2N 4AG1" COUNTRY="GBR" KEY1="29" KEY2="HOME" KEY3="02/10/2006" />

<PersAddr GEO_LOC_CD="US" EMPLID="29" ADDRESS_TYPE="MAIL" EFFDT="02/15/2006" ADDRESS1="92nd Floor" ADDRESS2="812backstreet" ADDRESS3="" ADDRESS4="" CITY="London" COUNTY="" STATE="AN" POSTAL="EC2N 4AG1" COUNTRY="GBR" KEY1="29" KEY2="MAIL" KEY3="02/10/2006" />

</Event>

REGARDS,

sridhar

[STALANKI · Accepted solution]

You can use fix value functions of the mapping editor and do it..It z like a value mappng only.

[sridharreddy_kondam · Accepted solution]

Hi Sravya,

Thanx for u r reply, That solved my problem....

Keep it up...

Thanks and Regards,

Sridhar reddy

[Former Member]

Hi,

This can be done using user-defined function as well.

Code the function as...

if(Addr_Type.equals("HOME"))

return "03";

else if(Addr_Type.equals("MAIL"))

return "05";

else

return "Invalid Address Type";

Here, Addr_Type is Input String Argument for this function.

Map this function between ADDRESS_TYPE and ANSSA.

Regards,

Uma

[Former Member]

hi,

You can solve this by using graphical mapping.

regards,

Smitha