.. _auto_dataset_get_row_by_condition:

*DATASET GET ROW BY CONDITION*
==============================

Filters a dataset to rows where a specified column satisfies a given condition (eq, contains, gt, between, excludes, etc.) and returns the matching row(s) as both a key-value pair and a dataset. Use this worker to isolate specific records from a tabular dataset based on column value logic.

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

Classification: **process**.

Tagged: ``column``, ``condition``, ``dataset``, ``filter``, ``query``, ``row``, ``transformation``.

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Dataset
     - dataset
     - dataset
     - —
     - 
     - The input tabular dataset to be filtered; accepts any d3VIEW dataset object.
   * - Column To Check
     - columntocheck
     - scalar
     - unclassified
     - 
     - Name of the column in the dataset to evaluate against the condition; default is 'unclassified' — replace with the exact column header string.
   * - Operator
     - operator
     - scalar
     - eq
     - 
     - Comparison operator to apply: 'eq' (equals), 'contains', 'numeric_contains', 'gt' (greater than), 'gte', 'lte', 'starts_with', 'ends_with', 'between', or 'excludes'; defaults to 'eq'.
   * - Value
     - value
     - scalar
     - —
     - 
     - The target value to compare each cell against using the chosen operator; for 'between', supply a delimited range (e.g., '10,20'); leave empty to match blank cells.

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - dataset_get_row_by_condition_output_1
     - dataset_get_row_by_condition_output_1
     - keyvalue
     - The first matching row returned as a key-value map, where keys are column names and values are the corresponding cell contents.
   * - Row As Dataset
     - dataset_get_row_by_condition_output_2
     - dataset
     - All matching rows returned as a dataset object, preserving the original column structure of the input dataset.

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

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