From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Connect Excel to a folder of files

Connect Excel to a folder of files - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Connect Excel to a folder of files

“

All right. Time to revisit the appending exercise that we went through in the last lecture. Now, if you recall, we had a 1997 file. We loaded up a 1998 file, and then appended the '97 data to create this kind of stacked version called Transactions_1997-1998. And that worked just fine. The only catch is that it left this component table, this 1997 table, on its own, and since it's dependent on it, we can't delete that one. So not a problem at all. You could move on and work with the data in its current form with no issue. But if you want to know an interesting way to kind of get around this, I'm going to show you how to point to a folder containing these files instead. So the first thing we're going to do is actually right-click and delete these two transactions table. Don't worry, it's not goodbye for good. We'll be getting those back in an even more efficient way. So got rid of both of the transaction files. You should just have your lookups left here. And now, what we're going to do…

Contents