.. _auto_dataset_get_rows_by_condition:

*DATASET GET ROWS BY CONDITION*
===============================

Filters a dataset to only the rows where a specified column satisfies a given condition (e.g., equals, contains, greater-than, between). Use this worker whenever you need a conditional row-subset of a dataset before passing it downstream in a workflow.

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

Classification: **process**.

Tagged: ``condition``, ``dataset``, ``filter``, ``query``, ``row_filter``, ``subset``, ``transformation``.

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Dataset
     - dataset
     - dataset
     - —
     - 
     - The source dataset whose rows will be filtered; must be a d3VIEW dataset object — leave empty only if the dataset is piped in dynamically from an upstream worker.
   * - Column To Check
     - columntocheck
     - scalar
     - —
     - 
     - Name of the column in the dataset against which the condition is evaluated; auto-populated from the connected dataset's column list.
   * - Operator
     - operator
     - scalar
     - eq
     - 
     - Comparison operator to apply: eq (exact match), contains / numeric_contains (substring / numeric membership), gt / gte / lte (numeric comparisons), starts_with / ends_with (string prefix/suffix), excludes (inverse membership), min / max (row with minimum or maximum value), or between (inclusive range); defaults to 'eq'.
   * - Value
     - value
     - scalar
     - —
     - 
     - The threshold or target value to compare against the selected column; for 'between', supply the bounds as a comma-separated pair (e.g., '10,50'); leave blank only when using min/max operators.

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - dataset_get_rows_by_condition_output_1
     - dataset_get_rows_by_condition_output_1
     - dataset
     - Filtered dataset containing only the rows from the input dataset that satisfy the specified column condition; retains the same schema (columns) as the input.

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