Merge Columns


Let’s say we have a table with user names in one column and their domains in the second column. Our task is to combine both columns to get a valid email list.


You have 2 alternatives to solve the task:

  1. Using Concat() function

  2. Using operator |


Concat("Meeting on ", Today()) -> "Meeting on 2023-01-20"
"Alex" | " " | "Brown" -> "Alex Brown"

Last updated