Hi Support Team,
We are writing data in AX server using AXSAXOutput. AX Server Save Decimal values in European format (1.01.00,00) The issue we are facing is the double format, As AX is configured in AX in European format. The data we put is in general format 10100.00. The problem is in writing in European decimal format. It is easy to ready data as per requirement and parse it.
We have also converted the format of Decimal using decimal functions. : java.text.NumberFormat.getNumberInstance(java.util.Locale.ITALY).format(10100.00) But it return a String not double value. And AX server reject any string value. And if we format it and parse it again to double using : noformat.parse(myString).doubleValue(); It remove all formatting and number get it's default format (10100.00). Please suggest if there is any solution for this.
Are you using tMSAXOutput component in your work flow? Could you please post your job setting screenshot on forum?
Hi @xdshi ,
The job is working perfectly apart from the decimal data issue.The snapshot is attached for your reference Please find the same. Any suggestion will be helpful.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.