---
title: "Array Functions"
description: "Efficiently manipulate and process arrays with a set of powerful array functions."
url: https://help.stackby.com/es/articles/75-array-functions
collection: "Using Formulas"
updated: 2025-01-10
language: es
alternates: [en]
---

# Array Functions

Efficiently manipulate and process arrays with a set of powerful array functions.

## An array formula is a formula that works with an array of values, rather than a single value. Array formulas can return a single result, or multiple results and it's separated by a comma.

## In Stackby, arrays can be used in conjunction with an aggregation or lookup column.   

## **ARRAYJOIN()** 

It is used to join the array of aggregation columns into a string with a separator. Used when formulas can't be achieved on array data types and must be converted to a string first.

**Syntax:** ARRAYJOIN(Values)  
**Result**: 

![](https://staticfiles.gleap.io/ghelparticle/Tqc9zepTRpDqKmektwDamroeqjfUSQKRJo2CwXmNxzcW0LEVb3F7PmRtAFMy9jCEvqxIAcMay2H.png)

## **ARRAYCOMPACT()**

It removes empty strings and null values from the array. Keeps "false" and strings that contain one or more blank characters.

**Syntax:** ARRAYCOMPACT(Values)

**Result :**

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/86a1ac62a0cb49ff9cfa5c49f073b166490357dca3b192a4ad8a29b6330971e31658378316960.png)

## **ARRAYUNIQUE()**

It only returns unique values from array

**Syntax:** ARRAYUNIQUE(Values)

**Result:**

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/552611e8cc0731007d05a43761cac9319974950ead6ad0a0bac5cdf324c2922d1658378467041.png)