Blending and Merging Datasets

So, you’ve got some workable datasets, but they’re all disconnected. We are going to convert the data into information and enrich it with these recipes, relating, joining, blending, or unioning datasets.

In this chapter, we’ll be exploring different methods to merge data sources, based on common fields or values, conditions, or schemas.

This chapter will cover the Join, Union, and Appending Fields tools through these recipes:

• Join or Find Replace
• Stacking data sources with different structures
• Joining tips and tricks
• Appending fields to a data source