# ClickHouse® tips #7: Forward and backfilling null values

DevFeed: [ClickHouse® tips #7: Forward and backfilling null values](<https://devfeed.tech/articles/clickhouse-tips-7-forward-and-backfilling-null-values-18724.md>)

Original publisher: [Read original article](<https://www.tinybird.co/blog/tips-7-filling-null-values-on-clickhouse>)

Author: Alejandra Rodríguez

Published: 2021-05-18T00:00:00Z

Content type: tutorial

Language: en

Sources: [Tinybird](<https://devfeed.tech/sources/tinybird.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [the-data-base](<https://devfeed.tech/tags/the-data-base.md>), [tips](<https://devfeed.tech/tags/tips.md>)

## AI overview

Part 7 of a ClickHouse tips series explains how to forward- and backfill null values using array functions.

## Source excerpt

Making use of array functions to do it. Part 7.