DATASET REPLACE COLUMN VALUE BY CONDITION¶
Replaces values in a specified dataset column based on one or more user-defined conditions (e.g., COL NAME = “abc” => NEW_VALUE). Use this worker when you need conditional value substitution in a dataset column without writing custom code.
When to use¶
Classification: process.
Tagged: column, conditional, dataset, query builder, replace, transform, value substitution.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Dataset | dataset | dataset | — | Input dataset whose column values will be conditionally replaced; accepts any tabular dataset available in the workflow context. | |
| Column To Check | columntoreplace | scalar | unclassified | Name of the target column whose values will be overwritten when a condition is matched; must be a valid column name present in the supplied dataset. | |
| Replacements | replacements | textarea | — | One or more conditional replacement rules expressed as COL NAME = “value” => NEW_VALUE; multiple rules are evaluated in order and the first matching condition per row applies. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| dataset_replace_column_value_by_condition_output_1 | dataset_replace_column_value_by_condition_output_1 | dataset | Transformed dataset identical to the input except that values in the target column have been replaced wherever a matching condition was satisfied. |
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_replace_column_value_by_condition
Auto-generated from transformation schema. Worker id: dataset_replace_column_value_by_condition. Schema hash: f00e8e85eead. Hand-curated docs in workerexamples/ override this page when present.