Dear,
Im facing an issue with the data readers whereby a value 37500.00 is being uploaded as 3750000
Grateful for guidance.
Rgds
the suggestions do not help
Despite having been able to fix the data reader with some substitution formula ,
it still shows wrong value 2,592,113 on the screen.
How do i fix this please.
thanks
Hi Khaleelah,
I'm assuming there are other combinations of data being uploaded.
In both the data reader and the screen, is it only this combination of data where this is happening or is it happening on every record you upload and review on the screen?
Any chance you can show the formulas with the ETL on the data reader?
On the screen, is there any other kind of formatting being applied?
Thanks, Kevin
Hello,
which kind of decimal seperator is configured on OS level for the system? Is it a dot or a comma? You can see this in newer versions like 14.5 or Board 15, in Diagnostic log, when the engine is started, for NET_ServerInitilize actions. For my system I, for example, get {"Culture":"de-DE", "NumberDecimalSeparator":",", "NumberDecimalSeparatorUnicode":"U+002C ", "NumberGroupSeparator":".", "NumberGroupSeparatorUnicode":"U+002E ", "CurrencyDecimalSeparator":",", "CurrencyDecimalSeparatorUnicode":"U+002C ", "CurrencyGroupSeparator":".", "CurrencyGroupSeparatorUnicode":"U+002E ", "ShortDatePattern":"dd.MM.yyyy", "ShortTimePattern":"HH:mm"} So on my system I am using the comma as decimal seperator. Maybe your system is configured in a similar way
Regards
Björn
I cannot see the Culture info in the diagnostic log, may be need to restart the engine to see it.
My observation is that it was ignoring the decimal point (.) as if it didnt exist and was apply the , separator after each 3 digits.
For the time being, i have removed the decimal point (it is plain number)from the csv file and uploaded to proceed.
However it is not a solution.
I dont understand.
