# To JSON

## 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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/dzOVaEU3EOgjce0gabxE/%D0%A1%D0%BD%D0%B8%D0%BC%D0%BE%D0%BA%20%D1%8D%D0%BA%D1%80%D0%B0%D0%BD%D0%B0%202023-08-17%20%D0%B2%2015.08.02.png" alt=""><figcaption></figcaption></figure>

## Settings

![](https://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/B87M3VOLJhp7OH7AdN6a/image.png)

#### 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.