CHAPTER 3Combining Data from Multiple Sources
The attempt to combine wisdom and power has only rarely been successful and then only for a short while.
—Albert Einstein
IN THIS CHAPTER, YOU WILL
Append tables from a few specified data sources
Append multiple Excel workbooks from a folder
Append multiple worksheets from an Excel workbook
While Albert Einstein’s quote may be correct, and wisdom and power have only rarely been combined successfully, with Power Query you have the power to combine multiple sources to gain a lasting wisdom. In this chapter you will learn how to combine multiple tables in various levels of complexity to gain insights from the combined datasets.
Chapter 2, “Basic Data Preparation Challenges,” discusses different scenarios ...
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.
