DATASET GET COLUMN VALUE BY CONDITION¶
Filters a dataset by one or more conditions on a specified column, then returns the matching value(s) from a second column as a scalar. Use this worker when you need to look up a cell value driven by conditional row selection — similar to a conditional VLOOKUP.
When to use¶
Classification: process.
Tagged: column, conditional, dataset, filter, lookup, scalar, vlookup.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Dataset | dataset | dataset | — | Input tabular dataset (any format accepted by the platform) whose rows will be filtered; leave unconnected only if the dataset is supplied inline. | |
| Column To Check | columntocheck | scalar | unclassified | Name of the dataset column whose values will be evaluated against the conditions (e.g. ‘Status’ or ‘Material_ID’); defaults to ‘unclassified’ — must be overridden with a real column name. | |
| Conditions | conditions | labelcondition | — | One or more label-condition rules (operator + value pairs) that the ‘Column to check’ must satisfy for a row to be selected (e.g. == ‘PASS’, > 0); repeatable to combine multiple filters. | |
| Column To Return | columntoreturn | scalar | unclassified | Name of the dataset column whose value is returned for every row that satisfies the conditions (e.g. ‘Result’ or ‘Score’); defaults to ‘unclassified’ — must be overridden with a real column name. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| dataset_get_column_value_by_condition_output_1 | dataset_get_column_value_by_condition_output_1 | scalar | Scalar value (or comma-separated list of values) extracted from ‘Column to return’ for all rows that matched the specified conditions. |
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_column_value_by_condition
Auto-generated from transformation schema. Worker id: dataset_get_column_value_by_condition. Schema hash: 0c1dc00aceb5. Hand-curated docs in workerexamples/ override this page when present.