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