.. _auto_bom_condition:

* FIND ROWS WITH A CONDITION FROM DATASET*
==========================================

Filters rows in a dataset by applying a conditional expression (e.g., equals, greater-than, contains) to a specified column. Use this worker to subset a dataset to only the rows where the chosen column satisfies the given operator and target value.

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

Classification: **process**.

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

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Choose Dataset
     - choose_dataset
     - dataset
     - None
     - 
     - Input dataset to filter; connect the upstream dataset node whose rows should be conditionally selected.
   * - Column Name
     - column_name
     - string
     - None
     - 
     - Name of the column in the dataset on which the filter condition will be evaluated (case-sensitive, must match an existing column header).
   * - Operator
     - operator
     - string
     - None
     - 
     - Comparison operator to apply (e.g., '==', '!=', '>', '>=', '<', '<=', 'contains'); defines how the column value is tested against the target.
   * - Target Value
     - target_value
     - string
     - None
     - 
     - The scalar value to compare against the selected column; provide as a string (numeric strings are coerced automatically where applicable).

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - bom_condition_output_1
     - bom_condition_output_1
     - dataset
     - Filtered dataset containing only the rows where the specified column satisfies the given operator and target value condition.

Disciplines
-----------

- data.dataset.transform

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>transformation</code> schema. Worker id: <code>bom_condition</code>. Schema hash: <code>1787af26c8e3</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>