Row Filter (DB)

Sets the criteria for filtering data set rows. Only the rows that meet the criteria remain in the output data set.

Information at a Glance

Note: You can also use this operator in a workflow that uses TIBCO® Data Virtualization and Apache Spark 3.2 or later.

Parameter	Description
Category	Transform
Data source type	DB
Send output to other operators	Yes
Data processing tool	n/a

Note: The Row Filter (DB) operator is for database data only. For Hadoop data, use the Row Filter (HD) operator.

You can specify row filters in the following modes.

Simple mode: Use a simple template to define the filter, choosing a column, an inequality (for example, ">" or "between"), and a value (for example, a literal value or a column expression).
Script mode: Enter almost any set of filters by using a SQL script.

A data set from the preceding operator.

Parameter	Description
Notes	Notes or helpful information about this operator's parameter settings. When you enter content in the Notes field, a yellow asterisk appears on the operator.
Filter	The filters for the operator. See Define Filter dialog for more information.

Output Type

Output Schema	The schema for the output table or view.
Output Table	Specify the table path and name where the output of the results is generated. By default, this is a unique table name based on your user ID, workflow ID, and operator.
Storage Parameters	Advanced database settings for the operator output. Available only for TABLE output. See Storage Parameters dialog for more information.
Drop If Exists	Specifies whether to overwrite an existing table. Yes - If a table with the name exists, it is dropped before storing the results. No - If a table with the name exists, the results window shows an error message.

Visual Output

The data rows of the output table or view displayed (up to 200 rows of the data).

Data Output

Either a newly created table or a view.

Did you find this helpful?

Yes No