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 4Combining Mismatched Tables

Combine the extremes, and you will have the true center.

Friedrich Schlegal

IN THIS CHAPTER, YOU WILL

  • Learn the impact of combining mismatched tables incorrectly

  • Correctly combine tables with mismatched column names

  • Correctly combine mismatched tables from a folder

  • Learn how to normalize column names by using a conversion table

  • Learn different solutions for table normalization with varied levels of complexity and performance constraints

In Chapter 3, “Combining Data from Multiple Sources,” you learned how to combine multiple tables in Power Query and append them together to simplify your analysis and reporting capabilities. Oftentimes, tables come to you in different formats, or they gradually change as ...

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