Evaluate rows number in a table
Description
Evaluate Rows Number in a Table counts the rows in a database table — either by connecting directly to the table or by running a custom SQL statement — and branches the process based on the result. Use this process entry to make data-driven decisions within a process — for example, checking whether new records exist before running a workflow, verifying that a staging table was populated correctly, or polling a table at intervals until data arrives.
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 | Name of the database connection on which the target table resides. |
| Target schema | The name of the Schema for the table to write data to. |
| Target table name | Name of the target table. |
| Success Condition: | |
| Success when rows count | For the success condition you can check the number of rows if they are: - Equal to - Different from - Smaller than - Smaller or equal to - Greater than - Greater or equal to |
| Limit | Give a numerical limit for the conditions above. |
| Custom SQL: | |
| Custom SQL | Check this option when you want to specify a custom SQL statement in the below field |
| Use variable substitution | Variables in the SQL statements will be substituted. |
| Clear list of result rows | Clears the internal list of result rows before executing. |
| Add rows to result | Adds all rows returned from the SQL statement within the internal list of result rows. This list of result rows can then be used in subsequent process entries to loop over or e.g. within a workflow by the Get rows from result step. |