---
title: "getDatasetValueByIndex"
description: "Retrieves a value from a global variable DatasetName created using the ExecuteQuery function."
---

# getDatasetValueByIndex

> Retrieves a value from a global variable DatasetName created using the ExecuteQuery function.

:::note Deprecated
This function was deprecated in 8.0.0.
:::

**This function is used by Ignition's Expression language.**
## Description
:::note
This function is only available in Transaction Group Expression Items and Expression Tags.
:::
## Syntax
`getDatasetValueByIndex(datasetName, row, column, fallback)`

- Parameters

    - string **datasetName** - The name of the dataset created using the executeQuery function.

    - int **row** - The row index

    - int **column** - The column index.

    - Object **fallback** - A fallback value if the lookup fails.

- Results
    - Object - The value at the given row and column index. They type returned matches the type of the value selected.

## Examples
For example, suppose you had a dataset called 'MyResult' with this information in it:

| ProductCode | Quantity | Weight |
|----|---|----|
| BAN_002 |	380 |	3.243 |
| BAN_010 |	120	 | 9.928 |
| APL_000 |	125 |	1.287 |
| FWL_220 |	322 |	7.889 |

```python title="Code Snippet"
getDatasetValueByIndex("MyResult", 0, 1, -1)  //would return 380
getDatasetValueByIndex("MyResult", 1, 2, -1)  //would return 9.928
getDatasetValueByIndex("MyResult", 0, 3, -1) //would return -1 because there is no fourth column and it reverts to the fallback value.
```