Custom column by concatenating 2 columns

Get Help
1

I need to concatenate 2 columns first_name and last_name to display as one single column (e.g first_name + ’ ’ + last_name) . How can this be achieved in metabse?

TIA

2

Hi @masoori
It’s currently not possible to do that in the GUI, but you can do it with SQL with concat (or whatever your database function is) or by creating a View in your database.
There’s a feature request open for adding support in the GUI:
https://github.com/metabase/metabase/issues/11330 - upvote by clicking :+1: on the first post

EDIT: It’s now possible since 0.35.0 with Custom Expressions: https://www.metabase.com/learn/building-analytics/notebook-editor/custom-expressions.html

3

Thanks flamber