1. Docs
  2. Formulas
  3. Functions

COMPACT

Removes any null values from an array.

Categories: Arrays

Syntax

COMPACT(array)

Examples

Example 1

Input

1
{
2
"my_action": {
3
"message": [
4
"one",
5
null,
6
"three",
7
"four",
8
null
9
]
10
}
11
}

Formula

COMPACT(my_action.message)

Output

1
[
2
"one",
3
"three",
4
"four"
5
]

Sample actions

Event Transform
COMPACT
Event Transform
My Action

Select an action to inspect

You can also click "Copy actions" and paste them in your Tines story to see how they work.

Was this helpful?