# Rows Union — Albato Help Center

Source: https://albato.com/wiki/articles/rows-union

Welcome to Albato Help

Search articles

# Rows Union

Last update:  
16/9/2026 · 4 min read

* * *

IN THIS ARTICLE

The **Rows Union** tool combines two row arrays into one dataset when both arrays describe the same items. Use it when one step returns a list of items and another step returns extra data for those same items, and the next step needs all fields together.

## When to Use Rows Union

Use **Rows Union** when:

-   Two automation steps return **Rows** instead of a single value.
-   Each row set contains different data about the same items.
-   Both row sets have a shared field, such as **SKU**, **Product ID**, **Email**, or **Code**.
-   The next step needs one combined row set.

> Note: Rows Union does not create or search for data. It matches two existing row arrays by a shared field and combines matching rows.

For example, a [WooCommerce](https://albato.com/apps/woocommerce) order can return product names and quantities, while a product search in another app can return product IDs or stock data. **Rows Union** can match both row sets by product name or SKU, then pass one combined dataset to the next action.

## Example: Create a Bitrix24 Deal from WooCommerce and HubSpot Data

This example takes product rows from **WooCommerce**, finds product details in [HubSpot](https://albato.com/apps/hubspot), combines both row sets with **Rows Union**, and creates a deal in [Bitrix24](https://albato.com/apps/bitrix24).

1.  Create a new automation. Choose **WooCommerce** as the trigger app and select the **Order created** event.

WooCommerce Order created trigger

2.  WooCommerce returns a **Rows** field with the products included in the order. Because an order can contain several products, add the **Iterator** tool and configure it to process **Rows Product** from the trigger.

Iterator tool after the WooCommerce trigger

3.  Add the **HubSpot: Search product** action.

HubSpot Search product action

4.  Use the product **Name** from WooCommerce as the search value.

HubSpot product search settings

HubSpot returns product details such as **Product ID**, **Product Name**, **Product Category**, **Stock Availability**, and **Product Price**.

5.  Add the **Aggregator** tool after the HubSpot action.

Aggregator tool after HubSpot

The **Aggregator** collects individual search results and converts them back into one **Rows** array. Add the fields you want to use later in the automation.

Aggregator fields

This array will become the second dataset for **Rows Union**.

6.  Add the **Rows Union** tool.

Rows Union tool

7.  In **Rows Union**, select the first and second row sources:

-   **First Rows Source**: **WooCommerce Product Row**.
-   **Second Rows Source**: **Aggregator Result** with HubSpot product data.

Rows Union row sources

8.  Configure the matching condition. In this example, both WooCommerce and HubSpot contain the same product name, so use **WooCommerce Name = Result Name**.

Rows Union matching condition

When the tool runs, it compares both arrays and merges matching rows. Instead of two separate datasets, the next action receives one combined row set.

> Note: Rows Union does not search for products. It only matches two existing arrays by a shared value.

9.  Add the **Bitrix24: Create deal** action.

Bitrix24 Create deal action

10.  Map fields from the combined row set. Because the rows were merged, you can use data from both WooCommerce and HubSpot in the same action.

Bitrix24 field mapping

11.  Activate the automation.

Activated automation

Now the automation can enrich order data from WooCommerce with product details from HubSpot before creating the deal in Bitrix24.

Use **Rows Union** whenever two steps return related **Rows** and the next step needs one complete dataset. You can match rows by values such as **Product ID**, **SKU**, **Product Code**, **Email Address**, **Contact ID**, or **Customer Code**.

For help, contact the support team through the chat.

Did this answer your question?