DATASET SET COLUMN VALUE BY CONDITION¶
Conditionally overwrites values in a target column based on one or more user-defined conditions evaluated against a separate check column. Use this worker whenever you need rule-driven cell updates — e.g., recoding labels, clamping outliers, or flagging rows — without writing custom code.
When to use¶
Classification: process.
Tagged: column set, conditional update, data wrangling, labelcondition, process, recode, row filter.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Dataset | dataset | dataset | — | Input dataset (tabular) whose column values will be conditionally updated; accepts any d3VIEW dataset object. | |
| Column To Check | columntocheck | scalar | — | Name of the column whose values are evaluated against the specified conditions (case-sensitive string matching the dataset header). | |
| Conditions | conditions | labelcondition | — | One or more label-condition rules (operator + threshold) applied to the check column; rows satisfying all conditions are eligible for the value update. | |
| Column To Set | columntoset | scalar | — | Name of the column whose cell values will be overwritten for rows that meet the conditions; leave blank to create a new column. | |
| New Value | new_value | scalar | — | Scalar value (string or numeric) to write into the target column for every row that satisfies the conditions. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| dataset_set_column_value_by_condition_output_1 | dataset_set_column_value_by_condition_output_1 | dataset | A copy of the input dataset with the target column updated to the new value for all rows that matched the specified conditions; all other rows and columns are unchanged. |
Disciplines¶
- data.dataset.transform
Runnable example¶
A runnable example is registered for this worker. Open the example workflow on the d3VIEW canvas: /api/workflow/example?id=dataset_set_column_value_by_condition
Auto-generated from transformation schema. Worker id: dataset_set_column_value_by_condition. Schema hash: 6b58d8eb74e0. Hand-curated docs in workerexamples/ override this page when present.