Combine Tables
Syntax:
concatenate(Table, Table)
cat(Table, Table)
Combines two tables into a new table. These tables have to have the same column types and names. You can use cat()as an alternative syntax:
Examples
Combine Columns
Syntax:
cat(Table.Column, Table.Column)
This formula joins two columns (of the same type) together, resulting in a new column. It can also add an element to the end or beginning of a column cat(Item, Column).