Merging and Appending

Data rarely lives in a single file. In this chapter, you'll learn two essential Power Query techniques for combining data: merging (adding columns from one table to another, like a VLOOKUP) and appending (stacking rows from multiple tables with the same structure).

You'll merge a category lookup table into the Products table to add a broader grouping level, then append three new products from a separate file into your existing Products table. You'll also load new dataset files (Returns, Targets, Category Lookup, and New Products) that will be used throughout the rest of the course.

Task

Download the four additional Summit Gear Co. CSV files needed for the rest of the course.

Task Steps

1. Download the following files from the course materials:
   • summit-gear-returns.csv
   • summit-gear-monthly-targets.csv
   • summit-gear-category-lookup.csv
   • summit-gear-new-products.csv
2. Save all four files in the same course folder where your original three CSV files are stored.

Expected Outcome

• Four new CSV files saved alongside the original Sales, Products, and Customers files
• Your course folder now contains seven CSV files total