---
schema_version: "1"
id: 4677c4453090f6ff134d6c5d09fa1c6fad6c94f11cb025b434140cae02746fc3
title: Multivalue Functions for Formulas
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_batch_transform_multivalue_functions.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_multivalue_functions.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 7bfccd99526118e040ab7136f6373d785a208dbe189fb83266d0b3766516a5c5
description: Multivalue data is limited to use in formulas. To work with multivalue data in downstream processes from batch data transforms in Data 360, such as reporting in CRM Analytics, convert it into a string.
products:
  - Data 360
release: "264"
---
# Multivalue Functions for Formulas

Multivalue data is limited to use in formulas. To work with multivalue data in downstream processes from batch data transforms in Data 360, such as reporting in CRM Analytics, convert it into a string.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_note.png)

Note Formula steps in transforms cannot directly output arrays. Therefore, functions that produce arrays, such as 'sequence', must be combined with functions that process arrays and return non-array results, such as 'explode' or 'array\_join'.

## `array_join`

Converts multivalue data into a string with elements separated by the specified delimiter. If no string is specified for nullReplacement, nulls are ignored.

### Syntax

```
array_join(mvField,delimiter,nullReplacement(optional))
```

### Parameters

- mvField—(Required) the multivalue text column to be converted to a string.
- delimiter—(Required) the value to separate the elements in the string. This can be a field or a text string.
- nullReplacement—(Optional) he value that replaces the nulls. This can be a field or a text string.

### Returns

A string that contains the multivalue data separated by the specified delimiter.

## `explode`

Converts an array into a new column where each element is a row.

### Syntax

```
explode(array)
```

### Parameters

- array—A field or formula expression.

### Example

```
explode(sequence(dateField1, dateField2, interval 6 months))
```

### Returns

Returns one row for each element in the array. The output includes a new field that has the value of each element in the array.

## `sort_array`

Sorts the input array in ascending or descending order according to the natural ordering of the array elements. Null elements will be placed at the beginning of the returned array in ascending order or at the end of the returned array in descending order.

### Syntax

`sort_array(array,ascendingOder)`

### Parameters

- array—(Required) is the array to be sorted..
- ascendingOrder—(Required) sorts the elements as strings in ascending order.

### Returns

The reference to the same array, now sorted.