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 result
Hi Bhaskar ,
You can use ternary operator to replace null value with number.
It worked. Had to remove the quotes before and after NULL.the condition looked like
Thanks much for the idea