Check if a column exists

Description

This steps allows you to verify the existence of a specific column in a database table.

Options

Option

Description

Step name

Name of the step; This name has to be unique in a single transformation

Connection

The database connection to use

Schema name

(optional) The schema name of the table of the column to check

Table name

The name of the table of the column to check

Tablename in field?

Enable to read the name of the table in an input field

Tablename field

Specify the fieldns containing parameters and the parameter type

Columnname field

The name of the column field in the input stream

Result fieldname

The name of the resulting boolean flag field

Example

 samples/transformations/Check if a column exists - Basic example.ktr