CHAPTER 5Preserving Context

For me context is the key—from that comes the understanding of everything.

Kenneth Noland


  • 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 ...

Get Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition 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.