# To JSON

<figure><img src="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FtWwSn0Hmbn8889oQrYwV%2FToolbar-JSON.png?alt=media&#x26;token=57dcf684-b307-4807-a58e-98fd1515c44d" alt=""><figcaption></figcaption></figure>

## Overview

The To JSON Node provides a powerful way to combine multiple columns into a single column with structured data, such as arrays or objects. This is especially useful when dealing with hierarchical or relational data and wanting to keep related values bundled together.

<figure><img src="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FnDoWn0FcELapHdQAJ9tS%2FJSON.png?alt=media&#x26;token=ccb498a7-d535-4596-afb0-f1cad7eb71e9" alt=""><figcaption></figcaption></figure>

## Settings

![](https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FPP5Rb5MGEXDdP4qDQ8x4%2Fimage.png?alt=media\&token=25ca5607-b6ca-4cfa-8fb6-a2296a6be71c)

#### Combine values from

Select one or multiple columns that you want to combine into JSON.&#x20;

#### Into

Choose a type of JSON to combine all columns into: an array or object.

Object. When an object type is selected, the column name is used as a key name, and column values as values.

```
{
  "Gender": "M",
  "Country": "USA",
  "BirthYear": 1980
}
```

Array. If you select array type information about column names will be lost.

```
["USA", "M", 1980]
```

#### Column name

Enter a name for the new column or select the column you want to overwrite. If you want to overwrite values in an existing column, enable toggle **Overwrite** and select the required column.