Using the WHERE clause - Cloud

Talend Data Shaping Language Reference Guide

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Data Shaping Language
Content
Design and Development

The WHERE clause is used to filter out the items that do not satisfy a condition given by an expression.

The WHERE keyword should be followed by a simple or conditional expression that returns a Boolean:
WHERE expression
You can specify several conditions using logical operators. For example:
WHERE hasValue(rating) && rating > 650

This clause should be used after a FROM, an UNNEST or a JOIN clause. If the query block contains a LET clause, the WHERE should be placed after it.