string to decimal error conversion
Moderators: chulett, rschirm, roy
string to decimal error conversion
Hello all,
My job is aborting because of this error generated by aggregator stage:
Value treated as NULL
Attempt to convert String value "26.50" to Decimal type unsuccessful
The think is the data looks like a decimal and the data type is also decimal.
Does anything need to be change on NLS ?
My job is aborting because of this error generated by aggregator stage:
Value treated as NULL
Attempt to convert String value "26.50" to Decimal type unsuccessful
The think is the data looks like a decimal and the data type is also decimal.
Does anything need to be change on NLS ?
No, this has nothing to do with NLS. Perhaps there are "hidden" characters in the string and I seem to recall that spaces cause issues as well. Do the explicit conversion in a modify or transform stage and you can also implement the IsValid() function to check on validity.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
The "," comma is the decimal separator in several NLS locales so you are correct and I was wrong - it is likely to do with NLS after all. What Locale do you have set - in German, for example, the default decimal separator is the "," character. Also, in the "edit row" attributes for the column in question, do you have "decimal separator" set - if not, try putting in a decimal point.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
The actual character set is not important - it is the NLS Locale which affects such things as date & time format, decimal separators, currency and collating order.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Did you try explicitly setting the delimiter in the column definition?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
right-mouse click on the column and choose "edit row"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
There is a category called "decimal separator" which lets you specify which character you wish to use.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>