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