Column exists
Description
The Column Exists transforms allows you to verify the existence of a specific column in a database table.
Options
| Option | Description |
|---|---|
Transform name | Name of the transform; This name has to be unique in a single pipeline |
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 |