isNull
Checks the value of an input column for a null value.
Use the following syntax:
Boolean isNull(String satrColName);
The following table describes the parameter:
Parameters | Parameter Type | Datatype | Description |
|---|
strColName | Input | String | Name of an input column. |
You can add the isNull method to the Java code on the On Input code entry tab.
The following Java code shows how to check whether the value of the SALARY input column is null before adding it to the totalSalaries instance variable:
// if value of SALARY is not null
if (!isNull("SALARY")) {
// add to totalSalaries
TOTAL_SALARIES += SALARY;
}
Alternatively, use the following Java code to achieve the same results:
// if value of SALARY is not null
String strColName = "SALARY";
if (!isNull(strColName)) {
// add to totalSalaries
TOTAL_SALARIES += SALARY;
}