Issues while Importing data in Currency field

vivek72
Tera Guru

‎11-27-2024 06:52 AM

Hi,

I am doing a data import using transform map on a currency field.

Issue is that it's rounding off the actual value.

E.g. Data in file is 2,122.87 but after import in SN, value is getting changed to 2,123.

 

Please suggest on possible ways to keep data in file and SN table exact same without rounding off.

Labels:
0 Helpfuls
  • 416 Views
2 REPLIES 2

Runjay Patel
Giga Sage

‎11-27-2024 07:01 AM

Hi @vivek72 ,

 

use below code to fix till 2 decimal .

Target.fieldName=currencyValue.toFixed(2);

 

0 Helpfuls

vivek72
Tera Guru
In response to Runjay Patel

‎11-28-2024 02:18 AM - edited ‎11-28-2024 02:19 AM

Hi @Runjay Patel 

 

Thanks for replying, I tried with changing format in file to text and it worked via transform map import.

However, if I am trying the same via manual import , it doesn't work.

Do you know any way to make it work via direct import.?

0 Helpfuls