0

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: Simple Data Extension

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]
  • what error you getting ? – pkharries Feb 19 at 5:19
  • Updated the original post with the output of the log file... – mercifulhop Feb 19 at 5:22
  • give like this data type Decimal field length 18 and 2 not like 18 and 0 – pkharries Feb 19 at 6:19
1

try like this see this image you get some ideaenter image description here

  • give length 18,2 not like 18,0 then import records – pkharries Feb 19 at 6:26
  • Thanks, I changed it from 18,0 to 18,2 and it worked – mercifulhop Feb 19 at 7:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.