COMPACT

Removes any null values from an array.

Syntax 

COMPACT(array)

Examples 

Example 1

Input

{
  "my_action": {
    "message": [
      "one",
      null,
      "three",
      "four",
      null
    ]
  }
}

Formula

COMPACT(my_action.message)

Output

[
  "one",
  "three",
  "four"
]
Was this helpful?