Check if a column exists
Description
Check if a column exists is a step in the Lookup Plugin for Process Studio Workflows. This step allows you to verify the existence of a specific column in a database table.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| 2 | Connection | Specify the database connection to use. |
| 3 | Schema name (optional) | Specify the schema name of the table containing the column to check |
| 4 | Table name | Specify the name of the table containing the column to check |
| 5 | Tablename in field? | Enable to read the name of the table in an input field |
| 6 | Tablename field | Specify the fields containing parameters and the parameter type |
| 7 | Columnname field | Specify the name of the column field in the input stream. |
| 8 | Result fieldname | Specify the name of the result boolean flag field. |