Merge multiple columns with a separator

New
April 16, 2021

In cases where you have separate columns with values that need to be mixed into one, you can use the merge multiple columns block. You can set a special character like “/” or “,”, that will be used to merge all the columns you specify. One use-case for this is when you have your day, month and year data types stored in multiple columns, and you want to merge them into one consistent column, using the “/” or “-” symbol.

A preview of merging the day, month and year column into one column named "Date", using the Merge multiple columns block.
select *

Merge multiple columns with a separator

New

In cases where you have separate columns with values that need to be mixed into one, you can use the merge multiple columns block. You can set a special character like “/” or “,”, that will be used to merge all the columns you specify. One use-case for this is when you have your day, month and year data types stored in multiple columns, and you want to merge them into one consistent column, using the “/” or “-” symbol.

A preview of merging the day, month and year column into one column named "Date", using the Merge multiple columns block.