GET THE CELL VALUE FROM GIVEN DATASET

Extracts a single cell value from a tabular dataset given a row and column index. The column may be addressed by zero-based integer position or by column name. Use this worker whenever you need to pull one scalar value out of a dataset for downstream processing.

When to use

Classification: process.

Tagged: cell_value, dataset, index, keyvalue, lookup, scalar_extraction.

Inputs

Label ID Type Default Required Description
Dataset Name datasetname dataset   The input tabular dataset from which the cell value will be extracted; must be a structured dataset object available in the workflow context.
Row Index row_index scalar 0   Zero-based integer row index of the target cell (default: 0, i.e. the first row); leave at default to read from the first row.
Col Index col_index scalar 0   Zero-based integer column index or column name string of the target cell (default: 0, i.e. the first column); pass a column header string to address by name instead of position.

Outputs

Label ID Type Description
dataset_get_cell_value_output_1 dataset_get_cell_value_output_1 keyvalue Key-value pair containing the extracted cell value; the value is null if the addressed row/column combination does not exist in the 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_cell_value_keyvalue


Auto-generated from transformation schema. Worker id: dataset_get_cell_value_keyvalue. Schema hash: e331a7476801. Hand-curated docs in workerexamples/ override this page when present.