.. _auto_dataset_select_row:

*DATASET SELECT ROW*
====================

Selects a single row from a dataset based on the minimum, maximum, or closest-to-average value in a chosen column. Use this worker when you need to reduce a multi-row dataset to one representative row for downstream processing or reporting.

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

Classification: **process**.

Tagged: ``avg``, ``dataset``, ``filter``, ``max``, ``min``, ``reduce``, ``row_selection``.

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Dataset To Select From
     - dataset_1
     - dataset
     - —
     - ✓
     - The input dataset to select a row from; must be a tabular dataset containing at least one column on which the selection criterion can be evaluated.
   * - Choose Column
     - columns
     - scalar
     - —
     - ✓
     - The column whose values drive the row-selection logic; for curve-type columns the curve values are used — choose the column most relevant to the desired selection criterion.
   * - Selection Type
     - selection_type
     - scalar
     - min
     - ✓
     - Aggregation rule used to pick the row: 'min' returns the row with the smallest column value, 'max' returns the row with the largest, and 'avg' returns the row whose value is closest to the column mean; defaults to 'min'.

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - dataset_merge_output_1
     - dataset_merge_output_1
     - dataset
     - A single-row dataset containing all original columns from the input dataset, corresponding to the row selected by the specified aggregation criterion.

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_select_row <https://www.d3view.com/api/workflow/example?id=dataset_select_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_select_row</code>. Schema hash: <code>077f7356d85c</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>