Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Couldn't parse value for column 'DispTime' in 'row1', value is 'NULL'. Details: java.lang.NumberFormatException: For input string: "NULL"
DispTime column is of integer type but when I'm converting it to String in tMap, its giving this error due to these NULL in column. Any solution?
try this :
Relational.ISNULL(row1.DispTime) ? '' : row1.DispTime.toString()
Hi
There exists string value "NULL" in source file, you should read this column as string data type.
Regards
Shong
It worked, thanks @Shicong Hong