Step 1: When you create a new connection, for example as shown here Connect To hadoop , you will get to Preview Screen.
Step 2: On preview screen,on right panel, you will see a section of "Other Operations".
Step 3: You get to see various options available under this section :
- Union data with another table - By selecting on "Union Data with another table" from the "Other operations" section, unions selected dataset with the existing dataset. You get a popup on selection over this tab, where you need to select the dataset with which you want to perform the union operation. And then finally you click on "Apply" to see the resulting operation.
