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¶
| 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¶
| 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
Auto-generated from transformation schema. Worker id: dataset_get_rows_by_condition. Schema hash: 2927201791f6. Hand-curated docs in workerexamples/ override this page when present.