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