Union - Latest

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265

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:

city

measure

Chicago

5000

Los Angeles

5500

New York

4750

Input 1

nameOfCity

cityMeasurement

Atlanta

3000

Portland

5125

Phoenix

4000

Input 2

Input 3

cityName

meas.

St. Louis

8000

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.

city

m

Chicago

5000

Los Angeles

5500

New York

4750

Atlanta

3000

Portland

5125

Phoenix

4000

St. Louis

8000

*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.