---
title: "Unique Operator"
slug: "unique-operator"
updated: 2025-09-26T02:29:22Z
published: 2025-09-26T02:29:22Z
canonical: "docs.unqork.io/unique-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.

# Unique Operator

UDesignerClassic Designer

## Overview

The **Unique operator** helps you remove duplicate values from your data set, leaving only distinct records. Doing so is especially useful when working with large data sources where repeated values can create confusion.

You'll find the Unique operator under the [Table](https://docs.unqork.io/Content/LandingPages/Landing_Table.htm) group to the left of the [Data Workflow](https://docs.unqork.io/Content/A06-ModEditor-Data_Workflow/A0601-General/A0601000A-Data_Workflow_Component.htm) canvas.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Unique_Operator_Udesginer_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D)

## About the Info Window

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

| Info |
| --- |
| 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. |
| Preserve Argument Type | When selected, this setting ensures the argument data type is respected when the operator executes. |
| Unique Keys | Tells the operator which data where to retrieve unique values. This key would be the name of the column of a data table. For example, if you have a column labeled **country**, you'd enter country here. > [!NOTE] > Keys are case sensitive and must match the capitalization of your column labels. |

## Adding a Unique Operator

In this example, you'll configure a [Data Table](/v1/docs/data-table-component) component that stores a list of countries. In the Data Table component, you'll include a couple of duplicate entries and set up a [Data Workflow](/v1/docs/data-workflow-component) to remove the duplicate entries.

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

### Configure the Data Table Component

First, configure a [Data Table](/v1/docs/data-workflow-component) component to store the list of countries. For this example, ensure to include duplicate entries to demonstrate how the Unique operator removes them.

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

|  | A |
| --- | --- |
| 1 | Countries |
| 2 | Afghanistan |
| 3 | Albania |
| 4 | Algeria |
| 5 | Cambodia |
| 6 | Czechia |
| 7 | Andorra |
| 8 | Austria |
| 9 | Afghanistan |
| 10 | Albania |
| 11 | Algeria |
| 12 | Afghanistan |

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UniqueOperator_Datatable_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D)
4. Click **Save Component**.

### Configure the Hidden Component

Next, you'll configure a [Hidden](/v1/docs/hidden-component) component to store the output from the Data Workflow.

1. Drag and drop a **H****idden** component onto your canvas, placing it below your **Data Table** component.
2. In the Property ID and Label Text fields, enter `uniqueCountries`.
3. Click **Save Component**.

### Configure the Data Workflow Component

Configure a [Data Workflow](/v1/docs/data-workflow-component) component to bring in the table data and remove the duplicate entries, returning only the distinct entries.

1. Drag and drop a **D****ata Workflow** onto your canvas, placing it between the ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/data_table_teal_component(20).png?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D) **Data Table** and **H****idden** components.
2. In the Property ID and Canvas Label Text fields, enter `dwfUnique`.
3. Navigate to the Actions tab.
4. Set the **Trigger Type** to ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/radioComponent_teal_icon(26).png?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D) **Watch**.

#### 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 | dtCountries |
| Required | Yes |
| Source | Default |

#### Configure the Unique Operator

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

| Info |
| --- |
| Category | Unique |
| Label | Show Unique Countries Only |
| Unique Keys | country |
3. Connect the output port (right) of the **dtCountries** **I****nput** operator to the input port (left) of the **Show Unique Countries Only** **U****nique** operator.

#### Configure the Output Operator

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

| Info |
| --- |
| Category | Output |
| Component | uniqueCountries |
| Action | value |
3. Connect the output port (left) of the **Show Unique Countries Only** **U****nique** operator to the input port (left) of the **uniqueCountries** **O****utput** operator.

#### Configure the Console Operator

Lastly, add a [Console](/v1/docs/console-operator) operator as an output to the Unique operator so you can review the results 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 | Unique Countries |
3. Connect the output port (left) of the **Show Unique Countries Only** **U****nique** operator to the input port (left) of the **Unique Countries** **C****onsole** operator.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UniqueOperator_DataWorkflow_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D)
4. Click **Save Component**.
5. **Save** your module.

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

**Preview** your module in Express View and open the DevTools Console. You'll see the Hidden component holding a list of countries, but each country displays only once.

[![A static image displaying the distinct data in the DevTools Console in Express View.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Dwf_UniqueOperator_Express_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D)](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Dwf%20UniqueOperator%20Express.jpg?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D)

## Overview

The **Unique operator** helps you remove duplicate values from your data set, leaving only distinct records. Doing so is especially useful when working with large data sources where repeated values can create confusion.

You'll find the Unique operator under the [Table](/v1/docs/table-operators) 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 |
| --- | --- |
| 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. |
| Preserve Argument Type | When selected, this setting ensures the argument data type is respected when the operator executes. |
| Unique Keys | Tells the operator which data where to retrieve unique values. This key would be the name of the column of a data table. For example, if you have a column labeled **country**, you'd enter country here. > [!NOTE] > Keys are case sensitive and must match the capitalization of your column labels. |

## Adding a Unique Operator

In this example, you'll configure a [Data Table](/v1/docs/data-table-component) component that stores a list of countries. In the Data Table component, you'll include a couple of duplicate entries and set up a [Data Workflow](/v1/docs/data-workflow-component) to remove the duplicate entries.

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

### Configure the Data Table Component

First, configure a [Data Table](/v1/docs/data-table-component) component to store the list of countries. For this example, ensure to include duplicate entries to demonstrate how the Unique operator removes them.

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

|  | A |
| --- | --- |
| 1 | Countries |
| 2 | Afghanistan |
| 3 | Albania |
| 4 | Algeria |
| 5 | Cambodia |
| 6 | Czechia |
| 7 | Andorra |
| 8 | Austria |
| 9 | Afghanistan |
| 10 | Albania |
| 11 | Algeria |
| 12 | Afghanistan |

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UniqueOperator_classicdatatable_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D)
4. Click **Save & Close**.

### Configure the Hidden Component

Next, you'll configure a [Hidden](/v1/docs/hidden-component) component to store the output from the Data Workflow.

1. Drag and drop a **H****idden** component onto your canvas, placing it below your **Data Table** component.
2. In the Property ID and Canvas Label Text fields, enter `uniqueCountries`.
3. Click **Save & Close**.

### Configure the Data Workflow Component

Next, configure a [Data Workflow](/v1/docs/data-workflow-component) component to remove the duplicate entries from the data table and return only the distinct entries.

1. Drag and drop a **D****ata Workflow** onto your canvas, placing it between the **D****ata Table** and **H****idden** components.
2. In the Canvas Label Text and Property ID fields, enter `dwfUnique`.
3. Navigate to the Actions tab.
4. Set the **Trigger Type** to **Watch**.

#### 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 | dtCountries |
| Required | Yes |
| Source | Default |

#### Configure the Unique Operator

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

| Setting | Value |
| --- | --- |
| Category | Unique |
| Label | Show Unique Countries Only |
| Unique Keys | country |
3. Connect the output port (right) of the **dtCountries** **I****nput** operator to the input port (left) of the **Show Unique Countries Only****U****nique** operator.

#### Configure the Output Operator

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

| Setting | Value |
| --- | --- |
| Category | Output |
| Component | uniqueCountries |
| Action | value |
3. Connect the output port (left) of the **Show Unique Countries Only** **U****nique** operator to the input port (left) of the **uniqueCountries** **O****utput** operator.

#### Configure the Console Operator

Lastly, add a [Console](/v1/docs/console-operator) operator as an output to the Unique operator so you can review the results 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 | Unique Countries |
3. Connect the output port (left) of the **Show Unique Countries Only** **U****nique** operator to the input port (left) of the **Unique Countries** **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/UniqueOperator_classicDataworkflow_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D)

1. **Save** your module.

Below is the completed configuration in the Module Builder:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UniqueOperator_classicMB_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D)

**Preview** your module in Express View and open the DevTools Console. You'll see the Hidden component storing a list of countries, but each country displays only once.

[![A static image displaying the distinct data in the DevTools Console in Express View.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Dwf_UniqueOperator_Express_thumb_0_0.jpg?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D)](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Dwf%20UniqueOperator%20Express.jpg?sv=2026-02-06&spr=https&st=2026-11-09T03%3A51%3A07Z&se=2026-11-09T04%3A51%3A07Z&sr=c&sp=r&sig=%2BsGWVorK9zLUB%2FsZXBTJqJ5vK1UfqdQQYuuh6g6ZMGQ%3D)

## Resources

- [Introduction to Data Workflow](/v1/docs/introduction-to-data-workflow)
- [Modifying Data Workflow Operators](/v1/docs/modifying-data-workflow-operators).
- [Introduction to Data Workflow Operators](/v1/docs/data-workflow-operators)
- [Data Workflow component](/v1/docs/data-workflow-component)
- [Input/Output Operators](/v1/docs/introduction-to-data-workflow-io-operators).
- [Table Operators](/v1/docs/table-operators).
- [Gateway Operators](/v1/docs/introduction-to-data-workflow-gateways-operators).

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

Label Text conveys what the input component is and what information it displays. Enter the purpose of the corresponding component or field.

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.

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.