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