Column Filter (DB)

Selects a subset of the columns from data source. Only the columns selected remain in the output dataset.

Information at a Glance

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

This operator is particularly helpful when there are many irrelevant columns in a data source that are not needed for the data analysis workflow.

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

A dataset from the preceding operator.

Parameter	Description
Notes	Any notes or helpful information about this operator's parameter settings. When you enter content in the Notes field, a yellow asterisk is displayed on the operator.
Columns	The columns to be made available for analysis. Click Select Columns to open the dialog box to specify columns. See Select Columns Dialog Box for more information.
Output Type	TABLE outputs a database table. Specifying TABLE enables Storage Parameters. VIEW outputs a database view.
Output Schema	The schema for the output table or view.
Output Table	The table path and name where the results are output. 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 Box 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.

Output

Visual Output: The data rows of the output table/view displayed (up to 2000 rows of the data).
Data Output: A dataset of the newly created table or view.