I have a source file. I am reading the file using seqential stage,one of the columns has a datatype double and contains amounts with '+' or '-' signs. when i view the data it is showing fine, but after sorting the file using a sort stage based on a different key column, in the output the '+' and '-' are missing. Can anyone help me out what might be the reason( the target field is also set to double with size same as the input).
The target is what - another sequential file, database table? And the signs are leading or trailing signs? Also, are you sure they are all "missing" or is it just the plus signs?
-craig
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote:The target is what - another sequential file, database table? And the signs are leading or trailing signs? Also, are you sure they are all "missing" or is it just the plus signs? ...
The target is sequential file. The signs are leading. only the signs are missing.