Check if a column exists

Description

Check If Column Exists verifies whether a specific column exists in a database table and returns a Boolean result. Use this step when your workflow needs to adapt its behavior based on table structure — for example, checking that expected columns are present before running a data load, or conditionally adding transformation logic when an optional column is available. The result field can drive downstream branching with a Filter Rows step.

Configurations

Field Name	Description
Step name	Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
Connection	Specify the database connection to use.
Schema name (optional)	Specify the schema name of the table containing the column to check
Table name	Specify the name of the table containing the column to check
Tablename in field?	Enable to read the name of the table in an input field
Tablename field	Specify the fields containing parameters and the parameter type
Columnname field	Specify the name of the column field in the input stream.
Result fieldname	Specify the name of the result boolean flag field.