DATASET MAP VALUES¶
Maps cell values in a destination dataset by looking up replacement values from a source dataset, using configurable column and value mappings. Use this worker when you need to recode, relabel, or substitute categorical or numeric values across two datasets without manual find-and-replace.
When to use¶
Classification: process.
Tagged: column_mapper, dataset_transform, lookup, map_values, process, recode, value_replacement.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Source Dataset | dataset_1 | dataset | — | Source dataset that provides the replacement values used in the mapping; its column values serve as the ‘new’ values substituted into the destination dataset. | |
| Destination Dataset | dataset_2 | dataset | — | Destination dataset whose cell values are to be replaced; the columns and values identified here are the targets that will be overwritten according to the mapping rules. | |
| Column Mapper | column_input | mapper | — | Column mapper that links columns from the source dataset (dataset_1) to the corresponding columns in the destination dataset (dataset_2); auto-matching is disabled so column pairings must be defined explicitly. | |
| Value Mapper | value_mapper | mapper | — | Value mapper that defines the specific cell-level substitutions — unique values from the destination dataset (dataset_2) are mapped to replacement values from the source dataset (dataset_1), using ‘/’ as the delimiter for compound keys. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| dataset_drop_columns_output_1 | dataset_drop_columns_output_1 | dataset | Resulting dataset identical in structure to the destination dataset (dataset_2) but with cell values replaced according to the configured column and value mappings. |
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_map_values
Auto-generated from transformation schema. Worker id: dataset_map_values. Schema hash: c5932fa7bf91. Hand-curated docs in workerexamples/ override this page when present.