Transform Script to update Location field in Transform Map

[Saib1]

Hi ,

I need to update the Target field based on the input from Source in Transform Map . 

Below is the Source Fields and Traget field

Need to hard code through script for the following 

For Example : if (San Newyork) update in target as Newyork

 Please help on this writing transform script.

[Sulabh Garg]

Hello

you can write source script as follows

if (source.<source field> == "San Newyork")

{

target.<target field> = "Newyork";

}

Hope it helps

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

[Saib1]

Hi ,

Need something like elsif ? I attached above with three rows

[Sulabh Garg]

Then do it like this

if (source.<source field> == "San Newyork")

{

target.<target field> = "Newyork";

}

else if (source.<source field> == "Oracle Melbourne")

{

target.<target field> = "Melbourne";

}

else if (source.<source field> == "WebLogic eCOM America" || source.<source field> == "VmMORREF.....")

{

target.<target field> = "America";

}

Hope it helps..!!

[Ankur Bawiskar]

Hi,

Since target field is reference you need to set sys_id OR you can use setDisplayValue() if you know the exact name of location

something like this; adding to what Sulabh shared

if (source.u_source_data_center == "San Newyork")
{
	target.setDisplayValue("locationField","Newyork");
}
else if (source.u_source_data_center == "Oracle Melbourne")
{
	target.setDisplayValue("locationField","Melbourne");
}
else if (source.u_source_data_center == "WebLogic eCOM America" || source.u_source_data_center == "VmMORREF.....")
{
	target.setDisplayValue("locationField","America");
}

Regards
Ankur