Scheduled Map is Rounding dollars on One Column but Running Manually Does Not
I’d like to figure out why this is happening when it is a csv file. We can only download it as a csv file so having the user download it and make them open it up just to save it as an xlsx file seems like an unneeded step. Especially when trying to explain to them why they need to do it.
Any thoughts on this?
Rounded or truncated?
If truly rounded (3.75->4.00) then you’d have to look in your code to see the rounding code that you have.
More likely it is truncated (3.75->3.00 or 3.15->3.00).
Press the create schema button and make sure your column is set to money or float and NOT integer.
It was truncating. I checked and it was set to Float in the schema. I changed it to Currency and that seems to have resolved the issue. Thanks for pointing me in the right direction.
Just out of curiosity, why would running it manually versus through a schedule have a different behavior?
I don’t have a real good answer for that but it might depend on the location of the file (local or unc path to server) and type of source.
If you would like to submit an answer or comment, please sign in to the eOne portal.