The Union tool allows you to append multiple data sets under each other or vertically, either by field name or record position. This tool is most useful if you need to consolidate or stitch multiple files together that have the same column name or column position. referred to referring to the illustration on the slide, if we start with the first picture, we have our 2018 cells on the left, and 2019 cells on the right. They contain the same columns, but this time the columns are ordered differently in the 2019 file. Please keep note of this. What we're going to do in this exercise is dragon two input files, connect them to the union tool, run the workflow, and we'll see that our data sets have been stacked under each other in the third picture.

Let's start a new workflow by dragging in two input data tools and connecting to our 3.2 spreadsheets. We'll connect to our 2018 sales at the top, and 2019 sales at the bottom. So we have our data sets in here that contain the same columns. But remember, this time the columns are ordered differently. In 2018, its revenue expenses profit year, and in 2019, it's here profit revenue expenses. Please keep note of this.

Let's go to the join tab and drag in a union tool and connected to both our data sets. In the configuration pane on the left, we have three main options of consolidating our data sets, either by column name, column position, or manually configuring the fields. Auto configuration by name will be the most relevant for us, because remember how each of our data sets contain the same columns, but in In different order. Well, using this option means it will automatically match the column names between our two sales data sets and consolidate our data. However, if we choose auto config by position, we have to make sure our two data sets have the same position, otherwise the output will be wrong. Lastly, there's the option to manually map the column names to each other, but we wouldn't need this for this video.

Under properties, we can tell ultrix what to do. If it can't find a common name to match against, we can either select error, which will terminate the process, select warning, which will throw a warning message in the results window but still continue processing records or select ignore which will just process records without any warning. Let's select order config by name and leave properties as warning as we still would like to see the results. Let's add a browse Tool by pressing Ctrl Shift B and we'll run out workflow With Ctrl r. and checking the output of the Union tool, we see our two sales datasets consolidated into one. If we were to rerun the workflows that have auto conflict by position, we can see that our data set has become mismatched. Through using the union tool, you now know how to easily consolidate multiple data sets.