> For the complete documentation index, see [llms.txt](https://docs.tabula.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/arrayif.md).

# ArrayIf

Creates an array from the values in the column filtered by the condition

```mathematica
ArrayIf(column2, StartsWith(column2, "M")) → ["Milk", "Macaroni",..]
ArrayIf(column1, column1 =="[1]") → ["[1]","[1]"]
```

#### Inputs

`ArrayIf(column, [condition])`

* `column` - A column to create an array from
* `[condition]` - **\[optional]** - Condition to filter values in the column