---
title: Combine Data Extensions without Matching Columns
slug: segment/combine-data-extensions-without-matching-columns
docTags: 
createdAt: 2026-01-15T20:25:56.331Z
---

:::hint{type="info"}
This feature is available on **Unaric Segment Plus **and **Advanced**.
:::

This page demonstrates how to use Row Number Custom Value to generate sequential numbers for records in different Data Extensions. By creating a Row Number column in two unrelated Data Extensions, you establish a common field that allows you to successfully combine them. In this way, you can combine Data Extensions that do not have any matching columns. 

For example, how can the user combine *Customers* and *Vouchers* Data Extensions to randomly match one voucher to a customer?

| Id    | First Name | Last Name | Email               |
| ----- | ---------- | --------- | ------------------- |
| C-001 | Anna       | Smith     | asmith\@hotmail.com |
| C-002 | John       | Doe       | jdoe\@gmail.com     |
| C-003 | Lorra      | Lee       | lorralee\@gmail.com |

| Voucher Code    | Promotion Name  | Discount Percentage |
| --------------- | --------------- | ------------------- |
| MSS-VOUCHER-001 | Mid Season Sale | 10                  |
| MSS-VOUCHER-002 | Mid Season Sale | 10                  |
| MSS-VOUCHER-003 | Mid Season Sale | 10                  |

## Setup

::::WorkflowBlock
:::WorkflowBlockItem
### Input

1. On the Home page, click **New** to create a new selection.
2. Drag the *Customers* Data Extension to the Selected Data Extensions section.
:::

:::WorkflowBlockItem
### Output

1. Click the **Create Data Extension** button, enter a name, e.g. *Customers with Row Number, *and press **Save**.
2. Add all the fields from *Customers* Data Extension by clicking the **Add all fields** button.
3. Under Custom Values, click **Add new value.**
4. Under Name, enter: *Row Number* and hit **Next**.
5. Choose Type: **Apply formula to a field**.
6. Choose Type: **Row Number**.
7. On the first drop-down list with the label *Data Extension*, choose **Customers***.*
8. On the second drop-down list with the label *Field*, choose **ID***.*
9. On the third drop-down list with the label *Order*, choose **Ascending **and hit **Save**.
10. Add the *Row Number field *to the Target Data Extension fields.
11. Hit **Save Data Extension** and **Create**.
:::

:::WorkflowBlockItem
### Preview

When the user clicks **Run Preview** on the Preview screen, the *Customer with Row Number* Data Extension should look like this.

| Id    | First Name | Last Name | Email               | Row Number |
| ----- | ---------- | --------- | ------------------- | ---------- |
| C-001 | Anna       | Smith     | asmith\@hotmail.com | 1          |
| C-002 | John       | Doe       | jdoe\@gmail.com     | 2          |
| C-003 | Lorra      | Lee       | lorralee\@gmail.com | 3          |

The user can now click on the **Run** button to run the selection.
:::

:::WorkflowBlockItem
### Repeat

Repeat the steps accordingly for Vouchers Data Extension. In the end, the Target Data Extension should look like this.

| Voucher Code    | Promotion Name  | Discount Percentage | Row Number |
| --------------- | --------------- | ------------------- | ---------- |
| MSS-VOUCHER-001 | Mid Season Sale | 10                  | 1          |
| MSS-VOUCHER-002 | Mid Season Sale | 10                  | 2          |
| MSS-VOUCHER-003 | Mid Season Sale | 10                  | 3          |

Now, the user can combine the *Customers* and *Vouchers* Data Extension using the Row Number column.
:::
::::



****