7

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

Technical requirements

Even when there are no technical requirements per se in this chapter, I’d like to make sure about the use cases we’ll be tackling here, and ...

Get Alteryx Designer Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.