SAP Data services converting decimal point into Comma while writing data

[former_member599394]

Hi Experts,

I am trying to write/load decimal data type data into .csv files and Salesforce tables/api using data services 4.2 SP 10.

Data services converting the decimal field value from decimal point to comma resulting in following situation -

1. Target CSV File : Data is getting wrongly written. Ex: 1,234 instead of 1.234.

2. Target Salesforce table : Job is failing as Salesforce decimal/double field can't accept comma(,) in it.

We tried checking the locale codes from locale selector but nothing got resolved. snapshot of the current setting is also embedded below.

Could you please help by providing some guidance here.

Many Thanks!

Kkam

[akhileshkiran]

Hi Kamlesh Arya,

You can use the conversation functions like to_decimal and to_decimal_ext to convert the source data in to decimal format.

1.png

3.png

Regards,

Akhilesh Kiran N.

[former_member599394]

Hi Akhilesh,

Thanks for your suggestion.

The problem is not about converting any value to decimal. The field values are already of decimal type, which Data services is implicitly converting to comma(,) while loading into Target causing failure and wrong data load.

It needs some configuration changes but where exactly is what I am looking for.

Thanks,

Kamlesh