Buk data import into spm Demand table, having issues with Operating Expense field.

[siva58]

I am uploading data into ServiceNow Demand table(dmn_demand). all the fields are loading properly except Operating expense. this field was the currency type field. 

I have data in the format of $120 or 120. but still data was not successfully loaded into that field. 

[Tanushree Maiti]

Hi @siva58 

Just parse the value correctly. 

In following post - You will get sample script:

Setting Currency Field values via client-side script

https://www.servicenow.com/community/developer-forum/copy-the-string-data-into-currency-field/m-p/27...

https://www.servicenow.com/community/developer-forum/string-to-price-field-mapping/td-p/3369298