From the course: Excel Business Intelligence: Power Query
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Append queries - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Power Query
Append queries
- [Instructor] Next on the agenda, we've got appending queries. Now the appending tools live right next to the merge queries tool in that combined pane in the query editor. And when you open up the append options, you'll see a pretty simple dialog box. You can append just two tables or you can append three or more. In this case, what we're looking at here is the combination of two data tables, FoodMart_Transactions_1997 and FoodMart_Transactions_1998. Now appending queries allows you to combine or essentially just stack tables that share a common structure and set of columns. Now that's the most important key here, they have to share that common column structure and data type. So you can't try to stack a column that's formatted as a date in one table and a whole number in another. It won't let you do those mixed data types. So in this case, we're appending these two data tables and it's legal to do so because they each contain the same exact set of columns with the same defined data…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Power Query introduction27s
-
(Locked)
Meet Power Query aka Get & Transform2m 40s
-
(Locked)
The Query Editor3m 17s
-
(Locked)
Options for loading data in Excel1m 40s
-
Basic Power Query table transformations8m 6s
-
(Locked)
Text-specific query editing tools10m 17s
-
(Locked)
Number-specific query editing tools7m 41s
-
(Locked)
Date-specific query editing tools7m 39s
-
(Locked)
Create a rolling calendar with Power Query5m 2s
-
(Locked)
Add index and conditional columns with Power Query7m 44s
-
(Locked)
Group and aggregate data with Power Query7m 10s
-
(Locked)
Modify Excel workbook queries4m 18s
-
(Locked)
Merge queries7m 43s
-
(Locked)
Append queries5m 49s
-
(Locked)
Connect Excel to a folder of files9m 32s
-
(Locked)
Excel Power Query best practices2m 42s
-
(Locked)
Pivot and unpivot data with Power Query8m 52s
-
(Locked)
-