演算子 - 8.0

Talend Data Stewardshipユーザーガイド

Version
8.0
Language
日本語
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend Data Stewardship
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Data Stewardship
Content
データガバナンス > キャンペーンの管理
データガバナンス > タスクの割り当て
データガバナンス > データモデルの管理
データクオリティとプレパレーション > セマンティックタイプの管理
データクオリティとプレパレーション > タスク管理
管理と監視 > ユーザーの管理

以下のテーブルにより、基本モードで使用できる演算子がリスト表示されます。

演算子 詳細
タイプ 名前
Text is CustomerName is Smith -
is not FirstName is not John -
contains StatusCode contains 0AZ -
does not contain ItemID does not contain X32 -
starts with BankNumber starts with FR -
does not start with ItemID does not start with DE123 -
ends with BankNumber ends with 0089 -
does not end with BankNumber does not end with Y9 -
matches regex PostalCode matches regex ^[0-9]{5}(-[0-9]{4})?$ -
does not match regex SSN does not match regex ^\\d{3}-\\d{2}-\\d{4}$ -
is of type Location is of type Asia セマンティックタイプまたは標準タイプ(ブール値、日付、小数点、整数のいずれか)を選択します。
is empty DriverLicense is empty -
Number is equal to Age is equal to 21 -
is not equal to CustomerID is not equal to 16742 -
is greater than Age is greater than 17 -
is greater than or equal to Age is greater than or equal to 21 -
is less than Age is less than 16 -
is less than or equal to Age is less than or equal to 20 -
Date and time is equal to DateOfReceipt is equal to 2020-05-14 09:55:00 日付、時刻、その両方のいずれかを選択できます。
サポートされている形式は以下のとおりです。
  • yyyy-mm-dd、
  • hh:mm:ss、
  • yyyy-mm-dd hh:mm:ssです。
is not equal to ValidationDate is not equal to 2020-09-02
is before BirthDate is before 2003-12-16
is before or equal to ExpiryDate is before or equal to 2002-01-01
is after BirthDate is after 1983-12-31
is after or equal to BirthDate is after or equal to 1971-01-01
is in (month) HireDate is in month March

-

is on (day of the week) PublicationDate is on day of the week Friday

-

is on (day of the month) PublicationDate is on day of the month 16 -
Boolean is true Validity is true -
is false Validity is false -
is equal to Access is equal to Validity これらの演算子では、ブール値タイプの変数を2つ比較できます。
is not equal to Access is not equal to Validity