Import data that allows numeric negative values. Data type is defined as double on data schema - Text file has value as -99.24 it needs to be numeric and undertand it is a negative value. I said in flat file it is floating Double precision format 1,000.00. How can I do this workflow is failing after 100 records because it is not liking the negative sign
Hi @cwhite3
Just tried exactly as you describe and it works, got all my negative floating value in the output transition.
Can you check if there is no space or exotic negative character in your imported file ? It looks like a problem in the input file.
I suggest to try with a blank new file, putting yourself some negative and floating values in a unic column, just like I did.
Cedric
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
