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 some terminology related to them.
We are going to be using these concepts throughout this chapter:
- Join: Refers to an association between one or more data sources, based on one or more values from fields. We’ve used this functionality in previous recipes.
- Union: Refers to the operation where we stack multiple datasets (mostly with the same structure, even when they can have different ones) one on top of another.
- Append Fields: This is the operation where, for each record from one dataset, we add all the records from a second one. This is called Cartesian Product too.
- Find Replace: This is self-explanatory. We can find some value within a data source field and replace it with the values from another, but it is worth mentioning that Alteryx also allows us to append fields to a data...
