.. _auto_dataset_query:

*DATASET QUERY*
===============

Filters rows in a dataset using a C-style query expression applied to column values. Use this worker to subset a dataset based on conditional logic (e.g., `COL1 >= VALUE`) before passing it downstream in a workflow.

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

Classification: **process**.

Tagged: ``c-style``, ``dataset``, ``filter``, ``query``, ``query-builder``, ``row-filter``, ``subset``.

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Dataset
     - dataset
     - dataset
     - —
     - 
     - Input dataset (tabular) whose rows will be filtered; connect the upstream dataset node here — leave unconnected only if the dataset is injected by the workflow context.
   * - Query
     - query
     - textarea
     - —
     - 
     - Filter expression using column names and C-style syntax (e.g., `Speed >= 60 && Load < 200`); supports the visual Query Builder or free-text entry — leave blank to return all rows.
   * - Remove Non-Alphanumeric
     - remove_non_alphanumeric
     - string
     - no
     - 
     - When set to 'yes', strips non-alphanumeric characters from column names before applying the query; default is 'no' — set to 'yes' if column headers contain special characters that break the expression parser.

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - dataset_query_output_1
     - dataset_query_output_1
     - dataset
     - Filtered dataset containing only the rows that satisfy the query expression, preserving all original columns.

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

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