Anyone run into an InvalidDecimalScale error in the SFMC CSV data import?
I came up with a contrived example to test. I made my data extension super simple:
It's a data extension with three fields. A number, a decimal and text field. I'm uploading a very simple file:
Id,Hello,World
"89228","7.0","Bad"
"89229","0.00","Bad"
"89230","1","Good"
The third row uploads correctly. The first two do not. It looks like it's due to the values after the decimal point e.g. "7.0" or the "0.00"
The field is a decimal field? Why is there an error? Is there a way to fix this?
EDIT: Error I'm getting in the text file are:
Row Number Error Number Error Code Error Details Row Data
0 88340068 InvalidDecimalScale InvalidDecimalScale [89228][7.0][Bad]
1 88340069 InvalidDecimalScale InvalidDecimalScale [89229][0.00][Bad]