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

Automation 360