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. Using Concat() function

2. Using operator |

Examples

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