---
title: "Col2Array Operator"
slug: "col2array-operator"
updated: 2025-11-12T18:26:11Z
published: 2025-11-12T18:26:11Z
canonical: "docs.unqork.io/col2array-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.

# Col2Array Operator

UDesignerClassic Designer

The **Col2Array operator** converts a column in a table to an array. Tables are an indexed array of objects. The Col2Array operator converts an array of objects into an array of values.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Col2Array_operator_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)

You'll find the Col2Array operator under the [Table](/v1/docs/tableoperators) group to the left of the [Data Workflow](/v1/docs/data-workflow-component) canvas.

## About the Info Window

Learn more about each setting in the Col2Array operator's Info window:

| Info |
| --- |
| 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. |
| Preserve Argument Type | When selected, this setting ensures the argument data type is respected when the operator executes. |
| Drop Empty | When set to No, where the source column has empty cells, the final array has indexed, empty values (""). When set to Yes, the final array will not include the empty cells. |
| Path | Enter the name (column header) of the specific column you want to convert to an array. |
| Default Value | When **Drop Empty** is set to No, any empty cells in the source column are replaced with the default value entered here. |

## Adding a Col2Array Operator

In this example, you'll configure a [Data Table](/v1/docs/data-table-component) component to store random names, followed by a [Data Workflow](/v1/docs/data-workflow-component) component to convert the data table column into an array.

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

### Configure the Data Table Component

First, you'll configure a [Data Table](/v1/docs/data-table-component) component to store your data and input it into a Data Workflow component.

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

| # | A |
| --- | --- |
| 1 | name |
| 2 | Minna |
| 3 | Veronika |
| 4 | Theola |
| 5 | Albina |
| 6 | Ezekiel |

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Col2Array_dataTable_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)
4. Click **Save Component**.

### Configure the Data Workflow Component

Next, you'll configure a [Data Workflow](/v1/docs/data-workflow-component) component to retrieve the stored data and use a Col2Array operator to convert the column into an array.

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

#### Configure the Input Operator

1. Drag and drop an **I****nput** operator onto your **D****ata Workflow** canvas.
2. Configure the operator's **Info** window as follows:

| Info |
| --- |
| Category | Input |
| Component | dtTable |
| Required | Yes |
| Source | Default |

#### Configure the First Console Operator

Configure a [Console](/v1/docs/console-operator) operator before the Col2Array operator to view the current data in the DevTools Console.

1. Drag and drop a **C****onsole** operator onto your **D****ata Workflow** canvas.
2. Configure the operator's **Info** window as follows:

| Info |
| --- |
| Category | Console |
| Label | Before Col2Array |
3. Connect the output port (right) of the **I****nput** operator to the input port (left) of the **C****onsole** operator.

#### Configure the Col2Array Operator

1. Drag and drop a **C****ol2Array** operator onto your **D****ata Workflow** canvas.
2. Configure the operator's **Info** window as follows:

| Info |
| --- |
| Category | Col2Array |
| Label |  |
| Drop Empty | Yes |
| Path | name |
| Default Value |  |
3. Connect the output port (right) of the **I****nput** operator to the input port (left) of the **C****ol2Array** operator.

#### Configure the Second Console Operator

Now, add a second Console operator to view the converted array after the data passes through the Col2Array operator.

1. Drag and drop another **C****onsole** operator onto your **D****ata Workflow** canvas.
2. Configure the operator's **Info** window as follows:

| Info |
| --- |
| Category | Console |
| Label | After Col2Array |
3. Connect the output port (right) of the **C****ol2Array** operator to the input port (left) of the **After Col2Array** **C****onsole** operator.
4. Click **Save Component**.

Here's how the completed Data Workflow looks:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Col2Array_DataWorkflow_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)

### Configure the Button Component

Lastly, add a [Button](/v1/docs/button-component) component to trigger the Data Workflow and convert the column in the data table to an array.

1. Drag and drop a **Button** component onto your canvas, placing it between your **Data Table** and **D****ata Workflow** components.
2. In the **Property ID** field, enter `btnRunDWF`.
3. In the **Label Text** field, enter `Run Col2Array`.
4. From the **Action Type** drop-down, select **Event**.
5. From the **On Click** drop-down, select **dwfCol2Array**.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Col2Array_Button_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)
6. Click **Save Component**.
7. **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/Col2Array_Configuration_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)

**Preview** your module in Express View and open the DevTools Console. Click the button and check the data before and after the Col2Array operation.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Col2Array_Output_thumb_0_0(2).jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)

## Overview

The **Col2Array operator** converts a column in a table to an array. Tables are an indexed array of objects. The Col2Array operator converts an array of objects into an array of values.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Col2Array_Classic_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)

You'll find the Col2Array operator under the [Table](/v1/docs/tableoperators) group to the left of the [Data Workflow](/v1/docs/data-workflow-component) canvas.

## About the Info Window

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

| **Setting** | Description |
| --- | --- |
| 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. |
| Preserve Argument Type | When selected, this setting ensures the argument data type is respected when the operator executes. |
| Drop Empty | When set to `No`, where the source column has empty cells, the final array has indexed, empty values (""). When set to `Yes`, the final array will not include the empty cells. |
| Path | Enter the name (column header) of the specific column you want to convert to an array. |
| Default Value | When **Drop Empty** is set to `No`, any empty cells in the source column are replaced with the default value entered here. |

## Adding a Col2Array Operator

In this example, you'll configure a [Data Table](/v1/docs/data-table-component) component to store random names, followed by a [Data Workflow](/v1/docs/data-workflow-component) component to convert the data table column into an array.

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

### Configure the Data Table Component

First, you'll configure a [Data Table](/v1/docs/data-table-component) component to store your data and input it into a Data Workflow component.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Col2Array_classicdatatable_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)

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 `dtTable`.
3. To the left of the component's configuration window, click **D****ata**.
4. In the data table, enter the following:

| A |
| --- |
| **name** |
| Minna |
| Veronika |
| Theola |
| Albina |
| Ezekiel |
5. Click **Save & Close**.

### Configure the Data Workflow Component

Next, you'll configure a [Data Workflow](/v1/docs/data-workflow-component) component to retrieve the stored data and use a Col2Array operator to convert the data column into an array.

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

#### Configure the Input Operator

1. Drag and drop an **I****nput** operator onto your **D****ata Workflow** canvas.
2. Configure the operator's **Info** window as follows:

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

#### Configure the First Console Operator

Now, add a [Console](/v1/docs/console-operator) operator before the Col2Array operator to view the current data in the DevTools Console.

1. Drag and drop a **C****onsole** operator onto your **D****ata Workflow** canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label | Before Col2Array |
3. Connect the output port (right) of the **I****nput** operator to the input port (left) of the **C****onsole** operator.

#### Configure the Col2Array Operator

1. Drag and drop a **C****ol2Array** operator onto your **D****ata Workflow** canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Col2Array |
| Label |  |
| Drop Empty | Yes |
| Path | name |
| Default Value |  |
3. Connect the output port (right) of the **I****nput** operator to the input port (left) of the **C****ol2Array** operator.

#### Configure the Second Console Operator

Then, add a second Console operator to view the converted array after the data passes through the Col2Array operator.

1. Drag and drop another **C****onsole** operator onto your **D****ata Workflow** canvas.
2. Configure the operator's **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label | After Col2Array |
3. Connect the output port (right) of the **C****ol2Array** operator to the input port (left) of the **After Col2Array** **C****onsole** operator.
4. Click **Save**.

Here's how the completed Data Workflow looks:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Classic_col2arrayDW_thumb_0_0(1).jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)

### Configure the Button Component

Lastly, add a [Button](/v1/docs/button-component) component to trigger the Data Workflow and convert the column in the data table to an array.

1. Drag and drop a **Button** component onto your canvas, placing it between your **Data Table** and **D****ata Workflow** components.
2. In the **Property ID** field, enter `btnRunDWF`.
3. In the **Label Text** field, enter `Run Col2Array`.
4. To the left of the component's configuration window, click **Actions**.
5. Set the **Action Type** as **Event**.
6. From the **On Click** drop-down, select **dwfCol2Array**.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Classic_Col2array-button_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)
7. Click **Save & Close**.
8. **Save** your module

Below is the completed configuration in the Module Builder:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Classic_col2array-config_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)

**Preview** your module in Express View and open the DevTools Console. Click the button and check the data before and after the Col2Array operation.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Col2Array_Output_thumb_0_0(4).jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A36Z&se=2026-11-07T18%3A57%3A36Z&sr=c&sp=r&sig=fCEm7QMtNP4V%2BXImTGnJevALbzIKxwh8wF0D3FSMQ8o%3D)

## Resources

- [Input/Output Operators](/v1/docs/introduction-to-data-workflow-io-operators).
- [Gateway Operators](/v1/docs/introduction-to-data-workflow-gateways-operators).
- [Table Operators Landing Page](/v1/docs/tableoperators).
- [Array Operators Landing Page.](/v1/docs/array-operators)
- [Modifying Data Workflow Operators](/v1/docs/modifying-data-workflow-operators).

An array is a type of object that stores one or more data types. Data types supported in arrays include numbers, strings, and objects.

An object is a type of data structure that represents a single, self-contained entity that acts as a container for the characteristics of that entity.

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

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.