How to replace NULL value in Mapper

I have a file reader in my mapping. One of the column in the file contains NULL value. I am connection a mapper after the file reader. Is there any way to replace the NULL value with number? Tried using replace/replaceALL function but didn’t get the intended resultNULL

Hi Bhaskar ,
You can use ternary operator to replace null value with number.
eg:- $firstname==‘null’?0:’’

1 Like

It worked. Had to remove the quotes before and after NULL.the condition looked like
$firstname==null?2:$firstname

Thanks much for the idea