.. _auto_dataset_map_values:

*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
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - 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
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - 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 <https://www.d3view.com/api/workflow/example?id=dataset_map_values>`_

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>transformation</code> schema. Worker id: <code>dataset_map_values</code>. Schema hash: <code>c5932fa7bf91</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>