PPM Projects - How to Change the currency Type through Transform map from USD to something else, lets say CAD.

[Sulabh Garg]

Hi Experts,

I have a excel where we have projects which I want to load through transform map in Servicenow.

I am facing one issue to convert currency type from USD to CAD through transform map, Field mapping.

Please see screenshot for more information.

TIA.

[Saiganeshraja]

Can you share the transform map script you are using for the transform.

[Sulabh Garg · Accepted solution]

I am able to resolve the issue by using below script in field maps

return source.u_project_currency + ";" + source.u_budget_cost;

Here u_project_currency contains currency type USD/CAD etc. and u_budget_cost contains currency value.