Merge output example

The Merge action combines data from two tables with identical column headers, and stores the merged content in a third table or one of the two source tables. These examples demonstrate the output of two tables with identical column headers and the output of two tables with differing column headers.

Output of tables with identical column headers

For example, if you have a table of employees hired in September and a table of employees that were hired in October, this option will return a table of all the employees, with the October hires merged below the September hires.

Table 1: Employees hired in September
Employee Department Pay rate
John 101 50
Jill 102 35
Table 2: Employees hired in October
Employee Department Pay rate
Mike 103 40
Betty 104 50
Table 3: All employees
Note: The column headers in the output table are always lowercase.
employee department pay rate
John 101 50
Jill 102 35
Mike 103 40
Betty 104 50

Output of tables with differing column headers

In this example, the second table has a different column header. As a result, the third table contains the columns from the first source table with data from the second source table under the identical column headers, followed by the non-identical columns and data from the second source table.

Table 1: Employees hired in September
Employee Department Pay rate
John 101 50
Jill 102 35
Table 2: Employees hired in October
Employee Department Salary
Mike 103 40
Betty 104 50
Table 3: All employees
employee department pay rate salary
John 101 50
Jill 102 35
Mike 103 40
Betty 104 50