Update Row(s)
The Update Row(s) component modifies one or more rows in an existing DataTable by applying targeted updates based on defined criteria. It precisely identifies matching rows and updates only specified columns, leaving all other data and non-matching rows unaffected.
a. Targeted Modifications: Updates only designated column values while leaving the rest of the row’s data intact.
b. Conditional Scoping: Combines filtering (Must Match, Number of Conditions), sorting (Sort By), and caps (Number of Limits) to control exact execution scope.
Parameters
| Parameter | Description | Behavior |
|---|---|---|
| DataTable* | Select the target DataTable in which rows will be updated. | Scans the selected DataTable and updates only the rows that satisfy the defined condition set. |
| Columns to Update* | Define the specific column names and their corresponding new target values. | Only these specified columns are modified with the new values; all other columns remain unchanged. |
| Must Match* | Determines how multiple conditions are evaluated when identifying target rows. |
All Conditions (AND) – Rows are updated only if every condition evaluates to true.
Any Condition (OR) – Rows are updated if at least one condition evaluates to true. |
| Number of Conditions* | Specify the total count of comparison rules (0–50) used to identify target rows. | Dynamically displays that many condition rows (Column Name, Condition, and Value Text). |
| Sort By* | Specifies the column and order (Ascending or Descending) to sort records before applying updates. | Evaluates and orders matching rows prior to applying the update operation. |
| Number of Limits | Sets the maximum count of rows allowed to be updated. | Caps the update operation to the first N matching rows. If left empty, all matching rows are updated. |
| SELECT Query | Provide the SQL SELECT query used to identify and retrieve target rows. |
Tool Mode – Executes dynamically based on the user's request to the agent.
Manual Mode – Uses the exported JSON table schema to build a manual query template. |
| UPDATE Query | Provide the SQL UPDATE query used to modify matching rows in the table. |
Tool Mode – Executes dynamically based on the user's request to the agent.
Manual Mode – Uses the exported JSON table schema to build a manual update template. |
| Column Name (per condition) | Specifies the target column in the DataTable to evaluate for that condition row. | Identifies rows as a match based on cell content within this specific column. |
| Condition (per condition) | Defines the logical criterion to apply against the specified column value. | Evaluates logical match (e.g., Equals, Contains, Greater Than, Is Empty). |
| Value Text (per condition) | Specifies the value or string to compare against the column cell. | Tested against cell content using the selected condition operator. (Note: Text comparisons are case-sensitive.) |
| Parameter | Description |
|---|---|
| Timeout (seconds) | Maximum wait time for the download request to complete before the operation times out. Default: 30 seconds. |
| Retry count | The number of automated download attempts if the initial request fails. |
| Delay between retries (s) | Wait time between consecutive retry attempts. Default: 1 second. |
| Delay before execution (s) | Time to wait before the component starts processing. Default: 0 seconds. |
| Delay after execution (s) | Time to wait after the component finishes processing. Default: 0 seconds. |
| Continue on Error |
Determines the behavior when an unrecoverable error occurs:
Stop Workflow – Halts workflow execution. Continue – Skips this step and continues without passing the error downstream. Continue Using Error Output – Continues execution and routes error details through the error output handle. |
Output
| Output | Description |
|---|---|
| Table Schema | Returns the structural schema of the target DataTable, including column names, data types, and constraints. |
| Data Fetch | Returns the set of rows that matched the update conditions, reflecting their newly updated values. |
| Dataframe | Returns the full updated DataTable in a structured tabular format for downstream workflow processing. |
| Data Update | Returns a summary object in JSON format detailing the exact columns and values modified during execution. |
