Check if a column exists


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




Step name

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


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


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