.. _auto_dataset_get_cell_value:

*GET THE CELL VALUE FROM GIVEN DATASET*
=======================================

Retrieves the scalar value of a single cell from a dataset by zero-based row and column indices. Use this worker when you need to extract one specific value from a tabular dataset for downstream use in a workflow.

When to use
-----------

Classification: **process**.

Tagged: ``cell``, ``dataset``, ``index``, ``lookup``, ``scalar``, ``table``.

Inputs
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Dataset Name
     - datasetname
     - dataset
     - —
     - ✓
     - The tabular dataset from which to extract a cell value; must be a valid dataset object available in the workflow context.
   * - Row Index
     - row_index
     - scalar
     - 0
     - ✓
     - Zero-based integer row index of the target cell (e.g. 0 = first row); defaults to 0.
   * - Col Index
     - col_index
     - scalar
     - 0
     - ✓
     - Zero-based integer column index of the target cell (e.g. 0 = first column); defaults to 0.
   * - Missing Value
     - missing_value
     - scalar
     - null
     - ✓
     - Fallback scalar value returned when the specified row or column does not exist in the dataset; defaults to "null".

Outputs
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - Label
     - ID
     - Type
     - Description
   * - dataset_get_cell_value_output_1
     - dataset_get_cell_value_output_1
     - scalar
     - The scalar value found at the specified row/column intersection, or the configured missing-value sentinel if the cell is out of bounds.

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 <https://www.d3view.com/api/workflow/example?id=dataset_get_cell_value>`_

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>transformation</code> schema. Worker id: <code>dataset_get_cell_value</code>. Schema hash: <code>e4a792b392ec</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>