Developer Transformation Guide

10.4.1
- 10.5.2
- 10.5
- 10.4.0

Back Next

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;
}

Java Transformation API Reference

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal