Can run on: Windows, Linux

Table Exists

Description

The Table Exists step belongs to the Lookup plugin group in Process Studio workflows. Use the Table Exists step to check whether a table exists in a database.

For each incoming row, the step reads a table name from a field in the row, checks the database for a matching table, and adds a Boolean result field to the row. Because the step reads the table name from a field instead of a fixed value, a single step can check many different tables in one run.

Note

The step requires an incoming stream. When no step feeds the Table Exists step, the workflow check reports "No input received from other steps!". The step supports error handling, so rows that fail can be routed to an error hop instead of stopping the workflow.

Configurations

Field Name	Description
Step name	Specify a unique name for the step, which will help you identify and reference it easily when debugging or linking steps in the workflow. The field is mandatory.
Connection	Select the database connection for the table lookup. When no valid connection is selected, the dialog displays the error "Please select a valid connection!". Note: The Connection label changes to Local Connection or Shared Connection after you select a connection. The field is mandatory
(Button) Edit…	Select Edit to change the settings of the selected connection. Note: Edit stays unavailable until you select a connection, and remains unavailable for a shared connection.
(Button) New…	Select New to create a database connection.
(Button) Wizard…	Select Wizard to create a database connection with guided steps.
Schema name	Specify the schema to search for the table. Leave the field empty to use the default schema of the connection. The field accepts a static value or a variable.
(Button) Browse…	Click the button to list the schemas in the database and choose one. Note: When the connection exposes no schemas, the dialog displays "There is no schema available from this connection".
Tablename field	Select the field in the incoming row that holds the table name to check. The list shows the fields from the previous step. Enter table names in the source data, not in this field. Required - when the field is empty, the step fails with the error "Tablename is missing!", and the workflow check reports "Table fieldname is missing!". When the selected field is not present in the incoming row, the step fails with "Couldn't find field '<field name>' in row!". The field is mandatory.
Result fieldname	Specify the field name to hold the execution status of the step. The step adds the field to the row as a Boolean and returns one of two values: True: A matching table exists in the database. False: No matching table exists. The field is mandatory. Note: When the field is empty, the step does not start and logs "Result fieldname is missing!". Default value: result.