# The operators

Available in...

* Cloud API Services Platform
* Cloud Big Data
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Integration
* Cloud Data Management Platform
* Cloud Pipeline Designer Standard Edition
* Data Fabric
* Qlik Talend Cloud Enterprise Edition

The following table lists the operators available in basic mode.

Text operators available in basic modeText operators available in basic mode

| Operator name | Example and details |
| --- | --- |
| is | CustomerName<br>is<br>Smith |
| is not | FirstName<br>is not<br>John |
| contains | StatusCode<br>contains<br>0AZ |
| does not contain | ItemID<br>does not contain<br>X32 |
| starts with | BankNumber<br>starts with<br>FR |
| does not start with | ItemID<br>does not start with<br>DE123 |
| ends with | BankNumber<br>ends with<br>0089 |
| does not end with | BankNumber<br>does not end with<br>Y9 |
| matches regex | PostalCode<br>matches regex<br>^[0-9]{5}(-[0-9]{4})?$ |
| does not match regex | SSN<br>does not match regex<br>^\\d{3}-\\d{2}-\\d{4}$ |
| is of type | Location<br>is of type<br>Asia<br><br>Select a semantic type or standard type: boolean, date, decimal, or<br>integer. |
| is empty | DriverLicense<br>is empty |

Number operators available in basic modeNumber operators available in basic mode

| Operator name | Example and details |
| --- | --- |
| is equal to | Age<br>is equal to<br>21 |
| is not equal to | CustomerID<br>is not equal to<br>16742 |
| is greater than | Age<br>is greater than<br>17 |
| is greater than or equal to | Age<br>is greater than or equal to<br>21 |
| is less than | Age<br>is less than<br>16 |
| is less than or equal to | Age<br>is less than or equal to<br>20 |

Date and time operators available in basic modeDate and time operators available in basic mode

| Operator name | Example and details |
| --- | --- |
| is equal to | DateOfReceipt<br>is equal to<br>2020-05-14 09:55:00<br><br>You can select a date or a time, or both. The supported formats are:<br><br><ul> <li>yyyy-mm-dd</li> <li>hh:mm:ss</li> <li>yyyy-mm-dd hh:mm:ss</li> </ul> |
| is not equal to | ValidationDate<br>is not equal to<br>2020-09-02<br><br>You can select a date or a time, or both. The supported formats are:<br><br><ul> <li>yyyy-mm-dd</li> <li>hh:mm:ss</li> <li>yyyy-mm-dd hh:mm:ss</li> </ul> |
| is before | BirthDate<br>is before<br>2003-12-16<br><br>You can select a date or a time, or both. The supported formats are:<br><br><ul> <li>yyyy-mm-dd</li> <li>hh:mm:ss</li> <li>yyyy-mm-dd hh:mm:ss</li> </ul> |
| is before or equal to | ExpiryDate<br>is before or equal to<br>2002-01-01<br><br>You can select a date or a time, or both. The supported formats are:<br><br><ul> <li>yyyy-mm-dd</li> <li>hh:mm:ss</li> <li>yyyy-mm-dd hh:mm:ss</li> </ul> |
| is after | BirthDate<br>is after<br>1983-12-31<br><br>You can select a date or a time, or both. The supported formats are:<br><br><ul> <li>yyyy-mm-dd</li> <li>hh:mm:ss</li> <li>yyyy-mm-dd hh:mm:ss</li> </ul> |
| is after or equal to | BirthDate<br>is after or equal to<br>1971-01-01<br><br>You can select a date or a time, or both. The supported formats are:<br><br><ul> <li>yyyy-mm-dd</li> <li>hh:mm:ss</li> <li>yyyy-mm-dd hh:mm:ss</li> </ul> |
| is in (month) | HireDate<br>is in month<br>March |
| is on (day of the week) | PublicationDate<br>is on day of the week<br>Friday |
| is on (day of the month) | PublicationDate<br>is on day of the month<br>16 |

Boolean operators available in basic modeBoolean operators available in basic mode

| Operator name | Example and details |
| --- | --- |
| is true | Validity<br>is true |
| is false | Validity<br>is false |
| is equal to | Access<br>is equal to<br>Validity<br><br>Use this operator to compare two variables of boolean type. |
| is not equal to | Access<br>is not equal to<br>Validity<br><br>Use this operator to compare two variables of boolean type. |