---
schema_version: "1"
id: f152e2bc4e993afa53818d9828ca889547903b69c4fa37ecbf582b93218bf862
title: ARRAY_CAT
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/scalar-func/array-func/array-cat.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-cat.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 60afff57f7d5d2dcb09191d0ff035f6b82c611f78a7bbe0ba23ad54961ee0630
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `ARRAY_CAT`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Concatenates two arrays into a single array.

## Syntax

```sql
array_cat(<array1>, <array2>)
```

## Arguments

### Required

- `<array1>`: The first array.
- `<array2>`: The second array to concatenate to the first.

## Returns

Returns an array that contains all elements from both input arrays in order.

## Considerations

- The resulting element type is non-nullable only if both input element types are non-nullable.
- Both arrays must have compatible element types, otherwise your SQL query will fail.

## Examples

### Concatenate Two Arrays

Combine two arrays.

```sql
SELECT array_cat(array[1, 2], array[3, 4]) AS result;
```

Returns `array[1, 2, 3, 4]`, combining both arrays.

### Concatenate with NULL Elements

Combine arrays where one contains NULL values.

```sql
SELECT array_cat(array[1, null], array[3, 4]) AS result;
```

Returns `array[1, null, 3, 4]`. The resulting element type is nullable when either input contains NULL.

## Related Documentation

- [Array Data Type](https://developer.salesforce.com/docs/data/data-cloud-query-guide/datatype/array.md)