Union - Latest

The Union node is used to combine data from two or more input nodes. The combined data sets should have the same structure, although they do not necessarily need to have the exact same field names, due to the Union node's Map Fields feature.

For example, if you had three sheets, and each sheet contained two columns:

Input 1

Input 2

Input 3

You could use the Union node to map the city, nameOfCity, and cityName fields to each other, and the measurement, cityMeasurement, and meas. fields to each other to create a new dataset combining the data from each input node.

*Note that the Map Fields feature will give your Output fields the same names as your leftmost input field by default; however, these names can be changed to anything you want by double-clicking on the Output Fields and typing.