Columns Exist In a Table
Description
Columns Exist in a Table verifies that one or more specified columns are present in a database table. Use this process entry as a precondition check before running workflows that depend on specific table structures — for example, confirming that required columns exist before a data load or verifying schema changes have been applied. The result determines which branch of the process executes next.
Configurations
| Field Name | Description |
|---|---|
| Process Entry name | Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name. |
| Connection | The database connection to use |
| Schema name | The schema of the table to use |
| Table name | The name of the table to use |
| Columns | The list of column names to verify (one or more) |