---
title: Extract from array
description: Extract specific element(s) from an array column in your dataset.
category: Data Transformation
tags: [array, extract, transform, sub-array, index]
---

# Extract from array

## Description

The **Extract from Array** activity enables the extraction of a specific element or a sub-array from an array-type column in your dataset. You can choose to extract a single item using an index or extract a range of values using a start and end index. This is particularly useful for data flattening, simplification, or isolating relevant subsets of structured arrays.

> **Use case**:  
> Commonly used when processing JSON arrays, time-series buckets, or nested API data where only a portion of the array is needed for downstream logic or display.

---

## Input

| Type | Description                                         |
| ---- | --------------------------------------------------- |
| Data | A dataset containing at least one array-type column |

---

## Output

| Type | Description                                    |
| ---- | ---------------------------------------------- |
| Data | Transformed data with extracted array elements |

---

## Configuration Fields

| Field Name            | Required    | Description                                                                                                                            |
| --------------------- | ----------- | -------------------------------------------------------------------------------------------------------------------------------------- |
| **Column Name**       | Yes         | The name of the column containing the array from which to extract values.                                                              |
| **Include Original**  | No          | If enabled, the original dataset is retained along with the new extracted column. If disabled, only the extracted values are included. |
| **Output Column**     | Yes         | The name of the new column where the extracted values will be stored.                                                                  |
| **Extract Sub-Array** | No          | When enabled, allows extracting a range (sub-array) of values using start and end indexes.                                             |
| **Index**             | Conditional | The index of the single element to extract. Required when **Extract Sub-Array** is disabled.                                           |
| **Start Index**       | Conditional | The starting index of the sub-array. Required when **Extract Sub-Array** is enabled.                                                   |
| **End Index**         | Conditional | The ending index (inclusive) of the sub-array. Required when **Extract Sub-Array** is enabled.                                         |

---

## Sample Input

| ID  | DataArray            |
| --- | -------------------- |
| 1   | [10, 20, 30, 40, 50] |
| 2   | [5, 15, 25, 35, 45]  |
| 3   | [100, 200, 300, 400] |

---

## Sample Configuration

| Field             | Value           |
| ----------------- | --------------- |
| Column Name       | DataArray       |
| Include Original  | false           |
| Output Column     | ExtractedValues |
| Extract Sub-Array | true            |
| Start Index       | 1               |
| End Index         | 3               |

---

## Sample Output

| ExtractedValues |
| --------------- |
| [20, 30, 40]    |
| [15, 25, 35]    |
| [200, 300, 400] |