Chapter 5. Data Preparation – Integrate and Format
In this chapter, we will cover:
- Speeding up a merge with caching and optimization settings
- Merging a lookup table
- Shuffle-down (nonstandard aggregation)
- Cartesian product merge using key-less merge by key
- Multiplying out using Cartesian product merge, user source, and derive dummy
- Changing large numbers of variable names without scripting
- Parsing nonstandard dates
- Parsing and performing a conversion on a complex stream
- Sequence processing