# ClickHouse® tips #3: the transform function

DevFeed: [ClickHouse® tips #3: the transform function](<https://devfeed.tech/articles/clickhouse-tips-3-the-transform-function-18721.md>)

Original publisher: [Read original article](<https://www.tinybird.co/blog/tips-3-transform>)

Author: Javi Santana

Published: 2021-02-25T00:00:00Z

Content type: tutorial

Language: en

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

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

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

## AI overview

A Part 3 tutorial on using the ClickHouse transform function to join two tables when joinGet is unavailable.

## Source excerpt

Using the transform function to join two tables when joinGet is not available. Part 3.