From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Appending data by leveraging folders

Appending data by leveraging folders

From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Start my 1-month free trial Buy for my team

Appending data by leveraging folders

“

- [Instructor] People will often compile their data together, meaning they'll put all of their datasets into a single dataset before they start leveraging tools like Power Query. I want to introduce you to the append data function by using folders. When we append data, what that really means is we're just compiling it all together. Let's say that every day we get a new set of data. Every day we get that data dump, we add it to the main data set we received. For some people, this means copying and pasting it to the bottom of a dataset that they're using for all their calculations or pivots. In queries, when you append, you're just copying it from one location to another. They're called append queries. And although this is not the only way to accomplish a single dataset from a group of datasets, it's very simple to perform. Let's take a look at our data folder inside our chapter exercise files. We have three rounds of data, but they're all the same structure, same field headings, so…

Contents