topic Re: How to only do a decode if the field is not null in Talend Studio

How to only do a decode if the field is not null

Anonymous — Wed, 26 Sep 2018 18:04:40 GMT

Hi I am currently using the code below for a decode but getting a null pointer when the value is null. Can someone let me know how I could check to see if the column is null before I do the decode. Below is my code

If not null then do below

(row1.PFR_REGION.equals("GULF"))?"3": (row1.PFR_REGION.equals("SF"))?"2": (row1.PFR_REGION.equals("QUEBEC"))?"6":row1.STATUS

Re: How to only do a decode if the field is not null

TRF — Wed, 26 Sep 2018 18:26:30 GMT

You can just reverse the comparisons if you want row1.Status as the default value:

"GULF".equals(row1.PFR_REGION) ? "3" :
  "SF".equals(row1.PFR_REGION) ? "2" :
      "QUEBEC".equals(row1.PFR_REGION) ? "6" : row1.STATUS

Else, if you want an other default value, change the expression like this:

row1.PFR_REGION == null ? "YOUR DEFAULT VALUE" :
    "GULF".equals(row1.PFR_REGION) ? "3" :
        "SF".equals(row1.PFR_REGION) ? "2" :
            "QUEBEC".equals(row1.PFR_REGION) ? "6" : row1.STATUS

Re: How to only do a decode if the field is not null

Anonymous — Thu, 27 Sep 2018 12:55:25 GMT

Thanks very much it works!