CHAPTER 5Preserving Context
For me context is the key—from that comes the understanding of everything.
IN THIS CHAPTER, YOU WILL
Learn how to preserve context from file names and worksheets when you append queries
Learn how to apply the Drill Down transformation on titles and dynamically preserve their content in tables
Preserve titles as a pre-append phase by using Drill Down and a custom column to combine multiple tables from a folder
Preserve titles as a post-append phase by using Drill Down, conditional columns, and the Fill Down transformation to combine multiple worksheets from a workbook
Learn advanced techniques for preserving specific cells from a grid using index and proximity cues
In Chapters 3, “Combining Data from ...