O'Reilly logo

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition by Gil Raviv

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 5Preserving Context

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

Kenneth Noland

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required