Table Exists
Description
Table Exists is a step in the Lookup Plugin for Process Studio Workflows. You can use the Table Exists step to verify if a certain table exists in a database. The result is a Boolean flag field that gets added to the input fields in the output.
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 | Specify the schema of the table to look for |
4 | Table name field | Specify the name of the field that will contain the database table name to look for. |
5 | Result fieldname | Specify the name of the field that will contain the Boolean result flag in the output of this step. |