Forum Discussion

sbhaskar85's avatar
sbhaskar85
New Contributor II
7 years ago

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 result

2 Replies

  • Ajay_Chawda's avatar
    Ajay_Chawda
    Contributor
    7 years ago

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

    • sbhaskar85's avatar
      sbhaskar85
      New Contributor II
      7 years ago

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

      Thanks much for the idea