Set currency as INR in transform map (for cost field)

[ShilpaWadhwani]

Hello experts!

I want to set the cost in INR currency for the assets I am importing from excel via transform map.

Target table - alm_hardware

Field - Cost

Field type - Currency

The default currency for our instance is Dollars. I don't want to change that. After I import the assets, the cost field should show value as Rs 1000 .

Please help!

Regards,

Shilpa

[asifnoor]

Hi,

Here is how you can do it in the transform script. 

target.your_currency_field= "INR;500"; //separate currency code and value with ;

Mark the comment as a correct answer and also helpful if it helps to solve the problem.