Point-and-Click Union

Unioning and Datameer

[Video Transcript]

Let’s take a look at Unioning and Datameer. Unioning can be tricky as schemas vary based on an easy-to-use point-and-click number of columns and data types. In Datameer, we have an easy-to-use point-and-click interface to define the union. First, by selecting my initial table and, therefore, by defining my output columns, I can add multiple data sets to my union, and Datameer will automatically line the columns up. And for example, we can fill in missing values so this auto loan does not contain the subgrade column, and then I can add a constant value to that.

Additionally, I can add output columns which are common with Unioning. For example, let’s say I wanted to define a column called Source, and I want to put in a constant value for each one of those tables that I am lining up so that we can keep track of what the source was. Once everything is set and lined up, we can choose the union type. We have UNION ALL, UNION, INTERSECT and EXCEPT. So we’re going to UNION ALL.

In this case, then I would go ahead and apply that, and then we will update the visual flow based on the union and the sources of that union, and then I can go on to calculate the row count of my stack data set as well as profile the newly created Union data set. Thank you.