DATASET SELECT ROW¶
Selects a single row from a dataset based on the minimum, maximum, or closest-to-average value in a chosen column. Use this worker when you need to reduce a multi-row dataset to one representative row for downstream processing or reporting.
When to use¶
Classification: process.
Tagged: avg, dataset, filter, max, min, reduce, row_selection.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Dataset To Select From | dataset_1 | dataset | — | ✓ | The input dataset to select a row from; must be a tabular dataset containing at least one column on which the selection criterion can be evaluated. |
| Choose Column | columns | scalar | — | ✓ | The column whose values drive the row-selection logic; for curve-type columns the curve values are used — choose the column most relevant to the desired selection criterion. |
| Selection Type | selection_type | scalar | min | ✓ | Aggregation rule used to pick the row: ‘min’ returns the row with the smallest column value, ‘max’ returns the row with the largest, and ‘avg’ returns the row whose value is closest to the column mean; defaults to ‘min’. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| dataset_merge_output_1 | dataset_merge_output_1 | dataset | A single-row dataset containing all original columns from the input dataset, corresponding to the row selected by the specified aggregation criterion. |
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_select_row
Auto-generated from transformation schema. Worker id: dataset_select_row. Schema hash: 077f7356d85c. Hand-curated docs in workerexamples/ override this page when present.