> For the complete documentation index, see [llms.txt](https://cgps.gitbook.io/data-flo/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://cgps.gitbook.io/data-flo/reference-guide/reshape-wide-to-long.md).

# reshape-wide-to-long

## Description

<mark style="color:purple;">`reshape-wide-to-long`</mark> *adaptor transforms a datatable to a two-column datatable in which one column contains the column names of the original datatable and the second column is the respective value from each row.*

## Inputs

**`data`**\
Type: `datatable`\
Required: Yes\
The datatable in wide format.

**`static columns`**\
Type: `list`\
Required: No\
The list of columns which will not be reshaped. If unspecified, all columns will be reshaped

**`key column name`**\
Type: `text`\
Required: No\
The name of the column to which keys are added. If unspecified, defaults to `key`.

**`value column name`**\
Type: `text`\
Required: No\
The name of the column to which values are added. If unspecified, defaults to `value`.

## Outputs

**`data`**\
Type: `datatable`\
A datatable in long format.

## Examples

### Example 1: Default behaviour.

#### Inputs:

`data:`

| id | code | country        |
| -- | ---- | -------------- |
| 1  | GB   | United Kingdom |
| 2  | TR   | Turkey         |
| 3  | US   | United States  |

`static columns:` *null (empty)*

`key column name:` *null (empty)*

`value column name:` *null (empty)*

#### Outputs:

`data`:

| key     | value          |
| ------- | -------------- |
| id      | 1              |
| code    | GB             |
| country | United Kingdom |
| id      | 2              |
| code    | TR             |
| country | Turkey         |
| id      | 3              |
| code    | US             |
| country | United States  |

-> Transformed all the columns in the datatable, from wide to long, using the default `key` and `value` as the column names

### Example 2: Reshape with static columns.

#### Inputs:

`data:`

| id | code | country        |
| -- | ---- | -------------- |
| 1  | GB   | United Kingdom |
| 2  | TR   | Turkey         |
| 3  | US   | United States  |

`static columns:`

1. country

`key column name:` *null (empty)*

`value column name:` *null (empty)*

#### Outputs:

`data`:

| key  | value |
| ---- | ----- |
| id   | 1     |
| code | GB    |
| id   | 2     |
| code | TR    |
| id   | 3     |
| code | US    |

-> Transformed the columns `id` and `code` in the datatable, from wide to long, using the default `key` and `value` as the column names. The `country` column was not reshaped.&#x20;

### Example 3: Reshape with specific key column name and value column name.

#### Inputs:

`data:`

| id | code | country        |
| -- | ---- | -------------- |
| 1  | GB   | United Kingdom |
| 2  | TR   | Turkey         |
| 3  | US   | United States  |

`static columns:`

1. country

`key column name:` name

`value column name:` result

#### Outputs:

`data`:

| name | result |
| ---- | ------ |
| id   | 1      |
| code | GB     |
| id   | 2      |
| code | TR     |
| id   | 3      |
| code | US     |

-> Transformed the columns `id` and `code` in the datatable, from wide to long, using the `name` as key column name and `result` as the value column name.