.. _auto_dataset_merge_text_columns:

*DATASET MERGE TEXT COLUMNS*
============================

Concatenates multiple text columns in a dataset into a single new column, joining values with a configurable delimiter. Use this worker when you need to combine string fields (e.g., ID + label + category) into one merged text column for downstream processing or reporting.

When to use
-----------

Classification: **process**.

Tagged: ``columns``, ``concatenate``, ``dataset``, ``merge``, ``string``, ``text``, ``transformation``.

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Dataset
     - dataset_1
     - dataset
     - —
     - 
     - Input dataset containing the text columns to be merged; must be a tabular dataset object available in the workflow context.
   * - Columns to Merge
     - col_name
     - scalar
     - —
     - 
     - One or more column names from dataset_1 whose text values will be concatenated together; select multiple columns in the desired merge order.
   * - New Col
     - new_col
     - scalar
     - MergedText
     - 
     - Name assigned to the output merged column; defaults to 'MergedText' if left unchanged.
   * - Delimiter
     - delimiter
     - scalar
     - ,
     - 
     - Character or string inserted between each merged column value (e.g., ',' for comma-separated); defaults to ',' if left unchanged.

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - Merged Dataset
     - merged_dataset
     - dataset
     - Copy of the input dataset with the additional merged text column appended, named according to the new_col parameter.

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

.. 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_merge_text_columns</code>. Schema hash: <code>0005daabacc2</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>