Relational Routines

Relational Routines - Cloud

Talend Cloud Data Management Platform Studio User Guide

EnrichVersion

Cloud

EnrichProdName

Talend Cloud

EnrichPlatform

Talend Management Console

Talend Studio

task

Design and Development

Relational routines allow you to check affirmations based on booleans.

You can access these routines by double-clicking the Relational node under the system routines folder in the Repository tree view. The Relational class contains several routines, notably:

Routine	Description	Syntax
`ISNULL`	Checks if the variable provided is a null value. It returns `true` if the value is NULL and `false` if the value is not NULL.	`Relational.ISNULL(variable)`
`NOT`	Returns the complement of the logical value of an expression.	`Relational.NOT(expression)`
`isNull`	Checks if the variable provided is a null value. It returns `1` if the value is NULL and `0` if the value is not NULL.	`Relational.isNull(variable)`

Routine

Description

Syntax

ISNULL

Checks if the variable provided is a null value.

It returns true if the value is NULL and false if the value is not NULL.

Relational.ISNULL(variable)

NOT

Returns the complement of the logical value of an expression.

Relational.NOT(expression)

isNull

Checks if the variable provided is a null value.

It returns 1 if the value is NULL and 0 if the value is not NULL.

Relational.isNull(variable)

To check a Relational Routine, you can use the ISNULL routine, along with a tJava component, for example:

String str = null;
System.out.println(Relational.ISNULL(str));

In this example, the test result is displayed in the Run view: