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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema