concat.md

title: Concat

Concat

concat joins text data (strings) from two or more columns.

Syntax	Example
concat(value1, value2, ...)	concat("Vienna, ", "Austria")
Combines two or more strings.	"Vienna, Austria"

Combining text from different columns

City	Country	Location
Vienna	Austria	Vienna, Austria
Paris	France	Paris, France
Kalamata	Greece	Kalamata, Greece

where Location is a custom column with the expression:

CONCAT([City], ", ", [Country])

Accepted data types

Data type	Works with concat
String
Number
Timestamp
Boolean
JSON

Related functions

This section covers functions and formulas that work the same way as the Metabase concat expression, with notes on how to choose the best option for your use case.

• SQL
• Spreadsheets
• Python

SQL

In most cases (unless you're using a NoSQL database), questions created from the notebook editor are converted into SQL queries that run against your database or data warehouse.

If our sample data is stored in a relational database:

SELECT
    CONCAT(City, ", ", Country) AS "Location"
FROM
    richard_linklater_films;

is equivalent to the Metabase concat expression:

concat([City], ", ", [Country])

Spreadsheets

If our sample data is in a spreadsheet where "City" is in column A, and "Country" in column B, we can create a third column "Location" like this,

=CONCATENATE(A2, ", ", B2)

which is equivalent to the Metabase concat expression:

concat([City], ", ", [Country])

Python

Assuming the sample data is in a dataframe column called df,

df["Location"] = df["City"] + ", " + df["Country"]

is the same as the Metabase concat expression:

concat([City], ", ", [Country])

Further reading

• Custom expressions documentation
• Custom expressions tutorial