Page Operations
Browse SpaceDescription
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