Update Rows
Description
This activity updates records in a database table using user-specified values.
Input
Data
Output
Updated data in the database
Configuration Fields
Connection Configuration options to establish a connection to the database. Key Columns Key columns that uniquely identify the records to update. Table The specific table within the selected data source where updates should be made. Column Map A set of mappings, specifying the column names and the transformations to apply.
Sample Input
Not Applicable
Sample Configuration
Sample Output
| ID | Name | Salary | Department |
|---|---|---|---|
| 101 | John Doe | 55000 | HR |
| 102 | Jane Smith | 66000 | HR |