---
title: "Transpose Operator"
slug: "transpose-operator"
description: "Learn how the Transpose operator transforms data from columns to rows, enhancing data organization and clarity in your tables."
updated: 2025-10-28T13:19:21Z
published: 2025-10-28T13:19:21Z
canonical: "docs.unqork.io/transpose-operator"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.unqork.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Transpose Operator

UDesignerClassic Designer

![A static image displaying the Transpose operator in the Data Workflow component.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Transpose UD.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

The **Transpose** **operator** transposes, or rotates, data from columns to rows in a table. Using this operator, you can also apply filters to the source data to isolate and group specific values in your output.

This operator works by adding two new columns to your data. The first new column is called `Key`, and it stores your previous column headers as values. The second new column is called `Value`, and it has the values for each row previously stored in the column you designated in the **Transpose Keys** setting. You can also set custom names for these columns using the **Transpose Name** and **Transpose Value** settings in the operator’s Info window.

Let’s say you have a column with the key of **Name**. In that column, you have the values `Josephine`, `Art`, and `Lenna`. You can use a Transpose operator to create a new column called **Key** (or any word of your choice). This new column stores three values: `Name`, `Name`, and `Name`. The operator also creates a new column called **Value** (or any word of your choice). This new column stores three values: `Josephine`, `Art`, and `Lenna`.

Another example of using this operator is when you have a data table that stores the worth of multiple companies. The Transpose operator converts the headers in your data table into values. These new values have their own header for clearer grouping.

You’ll find the Transpose operator under the [Table Operators](https://docs.unqork.io/docs/tableoperators) group to the left of the [Data Workflow](https://docs.unqork.io/docs/data-workflow-component) canvas.

## About the Info Window

Here's the breakdown of each setting in the Info window:

| Setting | Description |
| --- | --- |
| Category | Grayed out and non-adjustable setting indicating the operation type. |
| Label | Sets the label for your operator, displaying below the operator on your Data Workflow canvas. This field is optional, but set a label if you use more than one of the same operator type. A label helps you identify your operators without opening any Info windows. |
| Do Not Sanitize Formula | When this checkbox is clear, the operator cleans values coming into or defined in the operator. For example, removing special characters. Some of those special characters include `'`, `$`, `#`, and `&amp`. The operator also cleans up complex values. For example, logically breaking up strings of numbers and letters using underscores. A sample module ID can go from `5f6b4cdfabf886024d4de2d3 to 5f_6b_4cdfabf_886024d_4de_2d_3`. Sanitizing improves performance. But it can also lead to unexpected data behavior. If your Create Field is not behaving as expected, try selecting this box. When selected, the operator uses your values and expressions as-is. This is best when working with complex values or values that should remain unchanged. By default, this setting is selected, which means the operator does not attempt to sanitize. |
| Preserve Argument Type | When selected, this setting ensures the argument data type is respected when the operator executes. |
| Transpose Keys | The keys (headers) of the columns you want to transpose into values that display as rows in your data. |
| Transpose Name | The new key (column header) where your transposed column headers are stored as values. This setting is optional. If left blank, your new key (column header) defaults to `Key`. |
| Transpose Value | The new key (column header) where the values previously held in your transposed columns are stored. This setting is optional. If left blank, your new key (column header) defaults to `Value`. |
| Include Condition | A formula that tells your operator which data to operate on. This setting is optional, and you’ll only use it if you do not want to transpose all data in a key (column). For example, say you’re transposing data in a column with the key of **Company**, but you only want to transpose data for a certain company in that column. This formula looks like the following: `Company=”companyName”`, where `companyName` is the company you’re transposing. |

## Adding a Transpose Operator

Let's begin by configuring a [Data Table](https://docs.unqork.io/docs/data-table-component) component with company data. All columns have headers, which are your keys. The keys are Company, Country, Type, and Worth. Below each of these column headers, you have your values. In this example, let's say you want to rearrange the data so that `Company`, `Type`, and `Worth` are no longer keys but values. You can use the Transpose operator to do this.

> [!NOTE]
> These instructions assume you have a module open, saved, and with a title.

### Configure the Data Table Component

Let's begin with a 4-column [Data Table](https://docs.unqork.io/docs/data-table-component) component that stores your company details.

1. In the Module Builder, drag and drop a **Data Table** component onto your canvas.
2. In the **Property ID** and **Canvas Label Text** fields, enter `dtCompanies`.
3. In the data table, enter the following:

| # | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 | Company | Country | Type | Worth |
| 2 | JP Morgan | US | Investment Bank | 2.7B |
| 3 | RBS | UK | Retail Bank | 600B |
| 4 | TD | Canada | Asset Manager | 36B |

![A static image displaying the Data Table component.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Data Table UD.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)
4. Click **Save & Close**.

### Configure the Data Workflow Component

For the Transpose operator to work, you must input the data stored in your table. To bring your data into the Data Workflow, use an [Input](/v1/docs/input-operator) operator. You will use three Transpose operators to view three different structures. You’ll also configure four [Console](https://docs.unqork.io/docs/console-operator) operators to view how the data looks before and after each Transpose operator.

1. Drag and drop a **D****ata Workflow** component onto your canvas, placing it below your **Data Table** component.
2. In the **Property ID** and **Canvas Label Text** fields, enter `dwfTranspose`.

#### Configure the Input Operator

This operator references your source data.

1. Drag and drop an **Input** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Input |
| Component | dtCompanies |
| Required | Yes |
| Source | Default |

#### Configure the First Transpose Operator

You want `Company`, `Type`, and `Worth` to be values instead of keys. So, you’ll set these keys in the Transpose Keys field. That way, the key of `Country` stays the same, but `Company`, `Type`, and `Worth` become row values instead of keys (column names).

1. Drag and drop a **Transpose** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Transpose |
| Label | Company, Type, Worth |
| Do Not Sanitize Formula | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Checked_Box(7).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D) (checked) |
| Preserve Argument Type | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/icon_unchecked(1).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D) (unchecked) |
| Transpose Keys | Company, Type, Worth |
| Transpose Name | Classification |
| Transpose Value | Answer |
| Include Condition |  |
3. Connect the output port (right) of the `dtCompanies` **Input** operator to the input port (left) of the `Company, Type, Worth` **Transpose** operator.

#### Configure the First Console Operator

A Console operator lets you view how your source data displays in the DevTools Console before passing through the Transpose operator. This operator displays your key/value pairs in their original formatting.

1. Drag and drop a **Console** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label | Before |
3. Connect the output port (right) of the `dtCompanies` **Input** operator to the input port (left) of the `Before` **Console** operator.

#### Configure the Second Console Operator

Adding another Console operator lets you confirm the output of your Data Workflow in the DevTools Console. Doing so ensures that your Transpose operator is configured correctly.

1. Drag and drop a **Console** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label | Transposed |
3. Connect the output port (right) of the `Company, Type, Worth` **Transpose** operator to the input port (left) of the `Transposed` **Console** operator.

#### Configure the Second Transpose Operator

This Transpose operator restructures data by pivoting values associated with the `Country` key.

1. Drag and drop a **Transpose** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Transpose |
| Label | 1 |
| Do Not Sanitize Formula | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Checked_Box(7).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D) (checked) |
| Preserve Argument Type | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/icon_unchecked(1).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D) (unchecked) |
| Transpose Keys | Country |
| Transpose Name | countryname |
| Transpose Value | answer |
| Include Condition |  |
3. Connect the output port (right) of the `dtCompanies` **Input** operator to the input port (left) of the `1` **Transpose** operator.

#### Configure the Third Console Operator

Adding another Console operator lets you confirm the output of your Data Workflow in the DevTools Console. Doing so ensures that your Transpose operator is configured correctly.

1. Drag and drop a **Console** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label | after |
3. Connect the output port (right) of the `1` **Transpose** operator to the input port (left) of the `after` **Console** operator.

#### Configure the Third Transpose Operator

This Transpose operator restructures data by pivoting, namely `Country`, `Company`, `Type`, and `Worth`.

1. Drag and drop a **Transpose** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Transpose |
| Label | 2 |
| Do Not Sanitize Formula | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Checked_Box(7).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D) (checked) |
| Preserve Argument Type | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/icon_unchecked(1).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D) (unchecked) |
| Transpose Keys | Country, Company, Type, Worth |
| Transpose Name |  |
| Transpose Value |  |
| Include Condition |  |
3. Connect the output port (right) of the `dtCompanies` **Input** operator to the input port (left) of the `2` **Transpose** operator.

#### Configure the Third Console Operator

Adding another Console operator lets you confirm the output of your Data Workflow in the DevTools Console. Doing so ensures that your Transpose operator is configured correctly.

1. Drag and drop a **Console** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label | after2 |
3. Connect the output port (right) of the `2` **Transpose** operator to the input port (left) of the `after2` **Console** operator.

The image below is how your completed Data Workflow looks:

![A static image displaying the configuration of the dwfTranspose Data Workflow.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Data Workflow UD.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

### Configure the Initializer Component

Lastly, add an [Initializer](/v1/docs/initializer-component) component to trigger your Data Workflow. Set this Initializer component to run your Data Workflow every time you open your application.

1. Drag and drop an **I****nitializer** component onto your canvas, placing it above the `dtCompanies` **Data Table** component.
2. In the **Property ID** and **Canvas Label Text** fields, enter `initTranspose`.
3. Set the **Trigger Type** as **New Submission.**
4. In the **Outputs** table, enter the following:

| # | Property ID | Type | Value |
| --- | --- | --- | --- |
| 1 | dwfTranspose | trigger | GO |

![A static image displaying the Trigger Type and Outputs Table of the initTranspose Initializer.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Initializer UD.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)
5. Click **Save & Close**.
6. **Save** your module.

Here's how the completed example looks in the Module Builder:

![A static image displaying the Module configuration for explaining the Transpose Operator.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UD Transpose.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

This example works behind the scenes, so you won't see anything in Express View. Instead, here's a look at the DevTools Console:

![A static image displaying the outputs/actions of all components of the Module.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/DevTools Console Output1.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

In the `Before` **Console** arrays, you can see how the data looked originally:

![A static image displaying the output of the Before Console operator.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/DevTools Console Before(2).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

In the `Transposed` **Console** arrays, you can see the transposed data arrays, now displayed in rows:

![A static image displaying the output of the Transposed Console operator.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/DevTools Console Transposed(3).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

In the `after` **Console** arrays, you can see the transposed data arrays, now displayed in rows:

![A static image displaying the output of the after Console operator.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/DevTools Console After(2).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

In the `after2` **Console** arrays, you can see the transposed data arrays, now displayed in rows:

![A static image displaying the output of the after2 Console operator.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/DevTools Console After2.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

![A static image displaying the Transpose operator and its Info window.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Transpose CD.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

The **Transpose** **operator** transposes, or rotates, data from columns to rows in a table. Using this operator, you can also apply filters to the source data to isolate and group specific values in your output.

This operator works by adding two new columns to your data. The first new column is called `Key`, and it stores your previous column headers as values. The second new column is called `Value`, and it has the values for each row previously stored in the column you designated in the **Transpose Keys** setting. You can also set custom names for these columns using the **Transpose Name** and **Transpose Value** settings in the operator’s Info window.

Let’s say you have a column with the key of **Name**. In that column, you have the values `Josephine`, `Art`, and `Lenna`. You can use a Transpose operator to create a new column called **Key** (or any word of your choice). This new column stores three values: `Name`, `Name`, and `Name`. The operator also creates a new column called **Value** (or any word of your choice). This new column stores three values: `Josephine`, `Art`, and `Lenna`.

Another example of using this operator is when you have a data table that stores the worth of multiple companies. The Transpose operator converts the headers in your data table into values. These new values have their own header for clearer grouping.

You’ll find the Transpose operator under the [Table Operators](https://docs.unqork.io/docs/tableoperators) group to the left of the [Data Workflow](https://docs.unqork.io/docs/data-workflow-component) canvas.

## About the Info Window

Here's the breakdown of each setting in the Info window:

| Setting | Description |
| --- | --- |
| Category | Grayed out and non-adjustable setting indicating the operation type. |
| Label | Sets the label for your operator, displaying below the operator on your Data Workflow canvas. This field is optional, but set a label if you use more than one of the same operator type. A label helps you identify your operators without opening any Info windows. |
| Do Not Sanitize Formula | When this checkbox is clear, the operator cleans values coming into or defined in the operator. For example, removing special characters. Some of those special characters include `'`, `$`, `#`, and `&amp`. The operator also cleans up complex values. For example, logically breaking up strings of numbers and letters using underscores. A sample module ID can go from `5f6b4cdfabf886024d4de2d3 to 5f_6b_4cdfabf_886024d_4de_2d_3`. Sanitizing improves performance. But it can also lead to unexpected data behavior. If your Create Field is not behaving as expected, try selecting this box. When selected, the operator uses your values and expressions as-is. This is best when working with complex values or values that should remain unchanged. By default, this setting is selected, which means the operator does not attempt to sanitize. |
| Preserve Argument Type | When selected, this setting ensures the argument data type is respected when the operator executes. |
| Transpose Keys | The keys (headers) of the columns you want to transpose into values that display as rows in your data. |
| Transpose Name | The new key (column header) where your transposed column headers are stored as values. This setting is optional. If left blank, your new key (column header) defaults to `Key`. |
| Transpose Value | The new key (column header) where the values previously held in your transposed columns are stored. This setting is optional. If left blank, your new key (column header) defaults to `Value`. |
| Include Condition | A formula that tells your operator which data to operate on. This setting is optional, and you’ll only use it if you do not want to transpose all data in a key (column). For example, say you’re transposing data in a column with the key of **Company**, but you only want to transpose data for a certain company in that column. This formula looks like the following: `Company=”companyName”`, where `companyName` is the company you’re transposing. |

## Adding a Transpose Operator

Let's begin by configuring a [Data Table](https://docs.unqork.io/docs/data-table-component) component with company data. All columns have headers, which are your keys. The keys are Company, Country, Type, and Worth. Below each of these column headers, you have your values. In this example, let's say you want to rearrange the data so that `Company`, `Type`, and `Worth` are no longer keys but values. You can use the Transpose operator to do this.

> [!NOTE]
> These instructions assume you have a module open, saved, and with a title.

### Configure the Data Table Component

Let's begin with a four-column [Data Table](https://docs.unqork.io/docs/data-table-component) component to store your company details.

1. Drag and drop a **Data Table** component onto your canvas.
2. In the **Property ID** and **Canvas Label Text** fields, enter `dtCompanies`.
3. In the data table, enter the following:

| # | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 | Company | Country | Type | Worth |
| 2 | JP Morgan | US | Investment Bank | 2.7B |
| 3 | RBS | UK | Retail Bank | 600B |
| 4 | TD | Canada | Asset Manager | 36B |

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Dwf_TransposeOperator_DT_thumb_0_0.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)
4. Click **Save & Close**.

### Configure the Data Workflow Component

For the Transpose operator to work, you must input the data stored in your table. To bring your data into the Data Workflow, use an [Input](/v1/docs/input-operator) operator. You will use three Transpose operators to view three different structures. You’ll also configure four [Console](https://docs.unqork.io/docs/console-operator) operators to view how the data looks before and after each Transpose operator.

1. Drag and drop a **D****ata Workflow** component onto your canvas, placing it below your **Data Table** component.
2. In the **Canvas Label Text** and **Property Name** fields, enter `dwfTranspose`.

#### Configure the Input Operator

This operator references your source data.

1. Drag and drop an **Input** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Input |
| Component | dtCompanies |
| Required | Yes |
| Source | Default |

#### Configure the First Transpose Operator

You want `Company`, `Type`, and `Worth` to be values instead of keys. So, you’ll set these keys in the Transpose Keys field. That way, the key of `Country` stays the same, but `Company`, `Type`, and `Worth` become row values instead of keys (column names).

1. Drag and drop a **Transpose** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Transpose |
| Label | Company, Type, Worth |
| Do Not Sanitize Formula | Checked (yes) |
| Preserve Argument Type | Unchecked (no) |
| Transpose Keys | Company, Type, Worth |
| Transpose Name | Classification |
| Transpose Value | Answer |
| Include Condition |  |
3. Connect the output port (right) of the `dtCompanies` **Input** operator to the input port (left) of the `Company, Type, Worth` **Transpose** operator.

#### Configure the First Console Operator

A Console operator lets you view how your source data appears in the DevTools Console before it passes through the Transpose operator. This operator displays your key/value pairs in their original formatting.

1. Drag and drop a **Console** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label | Before |
3. Connect the output port (right) of the `dtCompanies` **Input** operator to the input port (left) of the `Before` **Console** operator.

#### Configure the Second Console Operator

Adding another Console operator lets you confirm the output of your Data Workflow in the DevTools Console. Doing so ensures that your Transpose operator is configured correctly.

1. Drag and drop a **Console** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label | Transposed |
3. Connect the output port (right) of the `Company, Type, Worth` **Transpose** operator to the input port (left) of the `Transposed` **Console** operator.

#### Configure the Second Transpose Operator

This Transpose operator restructures data by pivoting values associated with the `Country` key.

1. Drag and drop a **Transpose** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Transpose |
| Label | 1 |
| Do Not Sanitize Formula | Checked (yes) |
| Preserve Argument Type | Unchecked (no) |
| Transpose Keys | Country |
| Transpose Name | countryname |
| Transpose Value | answer |
| Include Condition |  |
3. Connect the output port (right) of the `dtCompanies` **Input** operator to the input port (left) of the `1` **Transpose** operator.

#### Configure the Third Console Operator

Adding another Console operator lets you confirm the output of your Data Workflow in the DevTools Console. Doing so ensures that your Transpose operator is configured correctly.

1. Drag and drop a **Console** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label | after |
3. Connect the output port (right) of the `1` **Transpose** operator to the input port (left) of the `after` **Console** operator.

#### Configure the Third Transpose Operator

This Transpose operator restructures data by pivoting, namely `Country`, `Company`, `Type`, and `Worth`.

1. Drag and drop a **Transpose** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Transpose |
| Label | 2 |
| Do Not Sanitize Formula | Checked (yes) |
| Preserve Argument Type | Unchecked (no) |
| Transpose Keys | Country, Company, Type, Worth |
| Transpose Name |  |
| Transpose Value |  |
| Include Condition |  |
3. Connect the output port (right) of the `dtCompanies` **Input** operator to the input port (left) of the `2` **Transpose** operator.

#### Configure the Third Console Operator

Adding another Console operator lets you confirm the output of your Data Workflow in the DevTools Console. Doing so ensures that your Transpose operator is configured correctly.

1. Drag and drop a **Console** operator onto your Data Workflow canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label | after2 |
3. Connect the output port (right) of the `2` **Transpose** operator to the input port (left) of the `after2` **Console** operator.

The image below is how your completed Data Workflow looks:

![A static image displaying the configuration of the dwfTranspose Data Workflow component.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Transpose DWF.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

### Configure the Initializer Component

Lastly, add an [Initializer](/v1/docs/initializer-component) component to trigger your Data Workflow. Set this Initializer component to run your Data Workflow every time you open your application.

1. Drag and drop an **I****nitializer** component onto your canvas, placing it above the `dtCompanies` **Data Table** component.
2. In the **Property ID** and **Canvas Label Text** fields, enter `initTranspose`.
3. Set the **Trigger Type** as **New Submission.**
4. In the **Outputs** table, enter the following:

| # | Property ID | Type | Value |
| --- | --- | --- | --- |
| 1 | dwfTranspose | trigger | GO |

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Dwf_TransposeOperator_Init_thumb_0_0.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)
5. Click **Save & Close**.
6. **Save** your module.

Here's how the completed example looks in the Module Builder:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Dwf_TransposeOperator_ModEdit_thumb_0_0.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

This example works behind the scenes, so you won't see anything in Express View. Instead, here's a look at the DevTools Console:

![A static image displaying the outputs/actions of all components of the Module.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/DevTools Console Output1.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

In the `Before` **Console** arrays, you can see how the data looked originally:

![A static image displaying the output of the Before Console operator.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/DevTools Console Before(2).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

In the `Transposed` **Console** arrays, you can see the transposed data arrays, now displayed in rows:

![A static image displaying the output of the Transposed Console operator.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/DevTools Console Transposed(3).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

In the `after` **Console** arrays, you can see the transposed data arrays, now displayed in rows:

![A static image displaying the output of the after Console operator.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/DevTools Console After(2).png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

In the `after2` **Console** arrays, you can see the transposed data arrays, now displayed in rows:

![A static image displaying the output of the after2 Console operator.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/DevTools Console After2.png?sv=2026-02-06&spr=https&st=2026-11-08T03%3A56%3A47Z&se=2026-11-08T04%3A56%3A47Z&sr=c&sp=r&sig=Emkmq%2FVJAcNoaThU8UUmc4mEft9OV5Ig8Rlb4%2Fre%2BsQ%3D)

A Property ID is the unique field ID used by Unqork to track and link components in your module.

Canvas Label Text indicates the purpose of the corresponding field or component. For non-input components, the Canvas Label Text isn't end-user facing, and only appears in the .

The DevTools Console helps you securely store, build, test, and deploy your software.

Deteremines how the component triggers.

The component fires when the page or called module loads without an existing submission ID. Dashboards and remote execute modules are great uses for this trigger.

Express View is how your end-user views your application. Express View also lets you preview your applications to test your configuration and view the styling. This is also the view your end-users will see when interacting with your application. After configuring a module, click Preview in the Module Builder to interact with the module in Express View.

## Related

- [Introduction to Data Workflow](/introduction-to-data-workflow.md)
- [Data Workflow Component](/data-workflow-component.md)