Int to String Number.Format.Exception

[MAli0012]

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?

[kakooo16]

try this :

Relational.ISNULL(row1.DispTime) ? '' :  row1.DispTime.toString()

[Anonymous]

Hi

There exists string value "NULL" in source file, you should read this column as string data type.

Regards

Shong

[MAli0012]

It worked, thanks @Shicong Hong​