Forum Discussion

amardeep2021's avatar
amardeep2021
New Contributor III
4 years ago

Getting "error_code": 1207 while validating before loading Redshift database

Hi All, I am trying to load a new redshift table which I have created. While validation, I am getting “error_code”: 1207 “error_message”: "Invalid digit, Value ‘.’, Pos 9, Type: Integer " “co...
jcornelius's avatar
jcornelius
New Contributor III
4 years ago
Copy LinkReport

text1 = “000000000”; //length you want

text2 = “1234”;

result = “000000000”.concat(text2);

0000000001234
//returns last number of characters
let result2 = result.slice(-9); //length you want

000001234

‘0’.repeat(9).concat(text2).slice(-9)