---
title: JOIN Operation
description: How to use the JOIN operation in formulas
---

[Skip to content](https://help.plytix.com/en/operations/join#main-content)

English

Show submenu for translations

![Plytix Logo](https://help.plytix.com/hs-fs/hubfs/4%20-%20Plytix%20Logo/Plytix-Logotype.png?width=150&height=61&name=Plytix-Logotype.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Talk to a specialist](https://www.plytix.com/get-started/explorer-call/)

[Talk to a specialist](https://www.plytix.com/get-started/explorer-call/)

 Hello! What can we help you with?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.plytix.com/en)
2. [Operations](https://help.plytix.com/en/operations)
3. [Text](https://help.plytix.com/en/operations#text)

# JOIN Operation

## How to use the JOIN operation in formulas

[Definition](https://help.plytix.com/en/operations/join#definition)

[Example](https://help.plytix.com/en/operations/join#example)

[Syntax Guide](https://help.plytix.com/en/operations/join#syntax)

[Formula In Use](https://help.plytix.com/en/operations/join#formula)

---

### Definition

The JOIN operation lets you concatenate, or link, values with a delimiter. 

---

### Example

JOIN(\["a", "b"\], "-")

Result:   
a-b

---

### Syntax Guide

JOIN(\[values\], delimiter)

**values** - The values to be appended using delimiter, confined by a set of brackets \[ \]

**delimiter** - The character or string to place between each concatenated value

ℹ️  The delimiter may be specified as blank, e.g. JOIN(\["1","2","3"\],) 

In this case the result would be: 1 2 3

---

### Formula In Use

![JOIN-1](https://help.plytix.com/hs-fs/hubfs/Help%20center/Operations/JOIN%20Operation/JOIN-1.jpg?width=688&height=858&name=JOIN-1.jpg)

 

---

### What's Next?

- Learn more about [how to write formulas](https://help.plytix.com/formula-cheat-sheet-and-guide)
- Learn how to [create an attribute transformations for channels and brand portals](https://help.plytix.com/create-computed-attributes)
- Check out the [LEN operation](https://help.plytix.com/operations/len)

---

 

 

- [Getting Started](https://help.plytix.com/en/getting-started#main-content)

    - [Import data](https://help.plytix.com/en/getting-started#import-data)
    - [Attributes](https://help.plytix.com/en/getting-started#attributes)
- [Using Plytix](https://help.plytix.com/en/using-plytix#main-content)

    - [Product Overview](https://help.plytix.com/en/using-plytix#product-overview)
    - [Product Editing](https://help.plytix.com/en/using-plytix#product-editing)
    - [Attributes](https://help.plytix.com/en/using-plytix#attributes)
    - [Product Lists](https://help.plytix.com/en/using-plytix#product-lists)
    - [Relationships](https://help.plytix.com/en/using-plytix#relationships)
    - [Asset Management](https://help.plytix.com/en/using-plytix#asset-management)
    - [Settings](https://help.plytix.com/en/using-plytix#settings)
    - [Product Families](https://help.plytix.com/en/using-plytix#product-families)
- [Sharing your data](https://help.plytix.com/en/sharing-your-data#main-content)

    - [Exports](https://help.plytix.com/en/sharing-your-data#exports)
    - [Webhooks](https://help.plytix.com/en/sharing-your-data#webhooks)
    - [Brand Portals](https://help.plytix.com/en/sharing-your-data#brand-portals)
    - [Channels](https://help.plytix.com/en/sharing-your-data#channels)
    - [Shopify](https://help.plytix.com/en/sharing-your-data#shopify)
    - [BigCommerce](https://help.plytix.com/en/sharing-your-data#bigcommerce)
    - [Syndication Guides](https://help.plytix.com/en/sharing-your-data#syndication-guides)
    - [Shopping Search Engines](https://help.plytix.com/en/sharing-your-data#shopping-search-engines)
    - [Ecommerce Platforms](https://help.plytix.com/en/sharing-your-data#ecommerce-platforms)
    - [Marketplaces](https://help.plytix.com/en/sharing-your-data#marketplaces)
    - [Feed Management Tools](https://help.plytix.com/en/sharing-your-data#feed-management-tools)
- [Admin](https://help.plytix.com/en/admin#main-content)

    - [General](https://help.plytix.com/en/admin#general)
    - [Billing](https://help.plytix.com/en/admin#billing)
    - [Team Roles](https://help.plytix.com/en/admin#team-roles)
- [Operations](https://help.plytix.com/en/operations#main-content)

    - [Date](https://help.plytix.com/en/operations#date)
    - [Info](https://help.plytix.com/en/operations#info)
    - [Logical](https://help.plytix.com/en/operations#logical)
    - [Lookup](https://help.plytix.com/en/operations#lookup)
    - [Math](https://help.plytix.com/en/operations#math)
    - [Operator](https://help.plytix.com/en/operations#operator)
    - [Statistical](https://help.plytix.com/en/operations#statistical)
    - [Text](https://help.plytix.com/en/operations#text)
- [Troubleshooting and FAQ](https://help.plytix.com/en/troubleshooting-and-faq#main-content)

    - [Imports](https://help.plytix.com/en/troubleshooting-and-faq#imports)
    - [Exports](https://help.plytix.com/en/troubleshooting-and-faq#exports)
    - [Attributes](https://help.plytix.com/en/troubleshooting-and-faq#attributes)
    - [Settings](https://help.plytix.com/en/troubleshooting-and-faq#settings)
    - [Product Families](https://help.plytix.com/en/troubleshooting-and-faq#product-families)
    - [Assets](https://help.plytix.com/en/troubleshooting-and-faq#assets)
    - [Brand Portals](https://help.plytix.com/en/troubleshooting-and-faq#brand-portals)
    - [Channels](https://help.plytix.com/en/troubleshooting-and-faq#channels)
    - [Shopify](https://help.plytix.com/en/troubleshooting-and-faq#shopify)
    - [Products](https://help.plytix.com/en/troubleshooting-and-faq#products)

[![Chill listening crop-3](https://help.plytix.com/hubfs/00%20Culture%20and%20branding/Branding%20-%20Logos/Plytix-logo-purple.svg "Chill listening crop-3")](https://help.plytix.com/)

Plytix Help Center

Copyright © 2026, Plytix.com, Inc.