snaplink22
Board Regular
- Joined
- Jul 6, 2018
- Messages
- 129
Hello,
I've been struggling with getting Power Query to combine 2 workbooks, with 2 tabs each. Here is my below setup:
1. Both workbooks are located in the same file folder on my desktop and are both .xlsx files.
2. Each tab's data has been converted to a table, with each table being named with the same prefix (WASS_) and the tabs titles follow the same naming convention. Each table and each tab has a different ending to their respective names however (e.g. WASS_Lindrick or WASS_Pasco)
3. On a new workbook, I select Data, Get Data, From File, From Folder. I select browse and then select the folder where these workbooks are stored.
4. Here's where things get a bit murky. I've seen a variety of videos and articles that reference what I'm supposed to do next, with each one being different. The options I have available are:
Combine drop down to select: "Combine & Transform, Combine & Load, and Combine and Load To"
Load drop down to select: "Load and Load To"
"Transform Data"
5. I've experimented with all of them, but the consequences seems to be "Transform Data". Which in turns give me this menu:
6. I removed all columns except the first two and then click on the double arrows under the Content header and select the table WASS_Lindrick1:
This, however, is where it deviates from all the videos as I only see 1 tabs worth of data displayed after clicking OK. Every thing that I've researched indicates I should be seeing all the data from all 4 of my tabs now, but I'm only seeing the first tabs data.
Any assistance would be greatly appreciated!
I've been struggling with getting Power Query to combine 2 workbooks, with 2 tabs each. Here is my below setup:
1. Both workbooks are located in the same file folder on my desktop and are both .xlsx files.
2. Each tab's data has been converted to a table, with each table being named with the same prefix (WASS_) and the tabs titles follow the same naming convention. Each table and each tab has a different ending to their respective names however (e.g. WASS_Lindrick or WASS_Pasco)
3. On a new workbook, I select Data, Get Data, From File, From Folder. I select browse and then select the folder where these workbooks are stored.
4. Here's where things get a bit murky. I've seen a variety of videos and articles that reference what I'm supposed to do next, with each one being different. The options I have available are:
Combine drop down to select: "Combine & Transform, Combine & Load, and Combine and Load To"
Load drop down to select: "Load and Load To"
"Transform Data"
5. I've experimented with all of them, but the consequences seems to be "Transform Data". Which in turns give me this menu:
6. I removed all columns except the first two and then click on the double arrows under the Content header and select the table WASS_Lindrick1:
This, however, is where it deviates from all the videos as I only see 1 tabs worth of data displayed after clicking OK. Every thing that I've researched indicates I should be seeing all the data from all 4 of my tabs now, but I'm only seeing the first tabs data.
Any assistance would be greatly appreciated!
