Union (In Database)

Synopsis

Appends a second data set to the first input data set.

Description

This operator combines two input data sets with the same or compatible schema, by appending the rows of the second input to the rows of the first input. Duplicate rows can be removed, but they are kept by default.

Input

example set 1

example set 2

Output

union

Parameters

Remove duplicates

Check to remove duplicates examples while creating the union.