The append fields tool allows you to take all the fields from a typically smaller data set and append all its columns and records into another larger data set, otherwise known as a Cartesian join. Referring to the illustration on the right. The first picture consists of an employee file and office location file. We want to combine both data sets to show that each employee works out of these two work locations. Therefore, the final data set after using the append fields tool would be nine columns, six from employees and three from office location, and 10 Records. five employees multiplied by two office locations gives you 10.

Let's go through this in ultrix. Let's start a new workflow by importing our 3.3 append fields spreadsheets. Let's go to the in app tab and drag into input data tools. And connect them to our 3.3 pin fields employee file and our 3.3 a pin fields officers file. Once we've done that will go to the join tab and drag in the pin fields tool. And you'll notice that there are two input anchors.

Here. The top anchor is for our main data set or target, and the bottom anchor is for our smaller or source data set. So we'll connect our offices dataset to that one. In the configuration pane on the left, we have the option to select D select, rename and resize our fields. Note that the source fields are prefixed with source. At the bottom we have the option of how to handle large data sets.

We can select for an error to appeal, a warning or just Have it all processed. We'll leave it as era for now. But this is important in the future because if you had 1000 employees in your first data set, and 10 office locations, you're all of a sudden end up with 10,000 Records, which is a lot to process. Finally, we'll add a browse Tool by pressing Ctrl Shift B. And then we'll run our workflow with Ctrl R. And we now have a full data set that shows the office locations for each employee.