.. _auto_dataset_merge:

*DATASET MERGE*
===============

Merges two or more tabular datasets into a single combined dataset by concatenating rows (union). Use this worker whenever you need to stack a base dataset with one or more additional datasets that share compatible columns.

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

Classification: **process**.

Tagged: ``combine``, ``concat``, ``dataset``, ``merge``, ``rows``, ``stack``, ``union``.

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Source Dataset
     - dataset1
     - dataset
     - —
     - 
     - The primary (base) source dataset whose rows will form the start of the merged output; must be a tabular dataset compatible with the columns of dataset2.
   * - Dataset 2
     - dataset2
     - dataset
     - —
     - 
     - One or more additional tabular datasets to append to dataset1; repeatable — add as many datasets as needed, provided their columns are compatible with the base dataset.

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - dataset_merge_output_1
     - dataset_merge_output_1
     - dataset
     - Single merged tabular dataset containing all rows from dataset1 followed by all rows from the appended dataset(s); column schema reflects the union of all input columns, with NaN fill where columns are absent in a given source.

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

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