.. _auto_dataset_add_row:

*DATASET ADD ROW*
=================

Appends one or more rows from a secondary dataset into a target dataset at a specified position (end, top, or relative to an index). Use this worker whenever you need to merge new records into an existing tabular dataset within a workflow.

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

Classification: **process**.

Tagged: ``add_row``, ``append``, ``dataset``, ``insert``, ``merge``, ``records``, ``row``.

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Dataset
     - dataset
     - dataset
     - —
     - 
     - The base dataset into which new rows will be inserted; leave empty to start from the rows supplied in `records` alone.
   * - records
     - records
     - dataset
     - —
     - 
     - A dataset whose rows will be inserted into the base dataset; each row must be column-compatible with `dataset`.
   * - Position
     - position
     - scalar
     - end
     - 
     - Where to insert the new rows: 'end' (default, append at bottom), 'top' (prepend), 'after_index', or 'before_index' for insertion relative to a specific row index.

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - dataset_add_row_output_1
     - dataset_add_row_output_1
     - dataset
     - The resulting dataset containing all original rows from `dataset` combined with the inserted rows from `records` at the specified position.

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

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