UNION

Formula Explanation

UNION is used in conjunction with UNION.select to vertically merge two or more tables.

• UNION should be written in the index column (the first column) of the result table.
• UNION.select should be written in the non-index columns of the result table.

Formula Syntax

Create a new table, enter in the index column: UNION(merged table index columns, merged table index columns, ...)
Create a new table, enter in the non-index columns: UNION.select(merged table content columns, merged table content columns, ...)

• Merged table index columns: The index columns (the first column) of the tables to be merged, can be multiple.

• Merged table content columns: All columns of the tables to be merged, can be multiple.

• Parameters can also be replaced with data column codes, which are the codes at the top of each column in the table, e.g., AA1.

Usage Example

Merge tables EW and EX, and write the result in table EY.

1. First, use UNION to concatenate columns EW1 and EX1, and write the result in column EY1.

EY1 = UNION(EW1, EX1)

2. Continue to merge columns EW2 and EX2, and write the result in column EY2.

EY2 = union.select(ew2,ex2)

✉️ Ask Tablize