Links
Comment on page

Merge Columns

Task

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.

Decision

You have 2 alternatives to solve the task:
  1. 1.
    Using Concat() function
  2. 2.
    Using operator |

Examples

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