Columns exist in a table

Description

The Columns exist in a table action verifies that one or more columns exist in a database table.

Options

Option	Description
Action name	The name of the workflow action.
Connection	The Relational Database Connection to use
Schema name	The schema of the table to use
Table name	The name of the table to use
Columns	The list of column names to verify (one or more)

Option

Description

Action name

The name of the workflow action.

Connection

The Relational Database Connection to use

Schema name

The schema of the table to use

Table name

The name of the table to use

Columns

The list of column names to verify (one or more)

Use the Browse buttons to select a database schema or table from the selected connection.

Use the Get columns button to retrieve the columns from the selected table.

Result

What this action passes on to the next action. See Action results for how results travel through a workflow.

Result	Value
True	Every column in the list exists in the table, with 0 errors.
False	A column doesn’t exist, the table doesn’t exist, the list of columns is empty, or the connection is empty, unknown or can’t be opened. The number of errors is 1.
Result files	Passed on unchanged.
Result rows	Passed on unchanged.
Lines written	The number of columns that exist in the table. When the connection is empty or unknown, Table name is empty or the list of columns is empty, the action stops before it checks anything and the value of the previous action is passed on unchanged.

Result

Value

True

Every column in the list exists in the table, with 0 errors.

False

A column doesn’t exist, the table doesn’t exist, the list of columns is empty, or the connection is empty, unknown or can’t be opened. The number of errors is 1.

Result files

Passed on unchanged.

Result rows

Passed on unchanged.

Lines written

The number of columns that exist in the table. When the connection is empty or unknown, Table name is empty or the list of columns is empty, the action stops before it checks anything and the value of the previous action is passed on unchanged.