Upsert Row(s)
This component allows users to update existing rows or insert new rows into a datatable based on defined conditions.
If matching rows are found, the specified columns are updated; if no match exists, a new row is inserted with the provided values. This ensures data consistency without requiring separate update and insert logic.
Parameters
| Parameter | Description |
|---|---|
| Datatable | Specifies the target DataTable where rows will be updated or inserted. |
| Columns to Upsert | Defines the column names and values used to update existing rows or populate new rows when no match is found. |
| Must Match |
Determines how the defined conditions are evaluated when identifying existing rows.
|
| Number of Conditions | Specifies the number of conditions (0–50) used to determine whether a matching row exists in the DataTable. Each condition compares a column value against a defined criterion. |
