Forum Discussion
Select Multiple Tables when data is retrieved from folders
Sorry, my bad. Didn'T read your thread carefully.
If I understood you correctly, you can do the following:
Start with the table containing the overview of all files in the folder and add a column with this formula:
Excel.Workbook( [Content] ).
This will return the same table that I mentioned in my first post or each row. Expand it and filter the tables you're after.
This method didn't work when I removed steps because i still had the full list of workbooks and not the tables from the file.
I am connecting to a folder with 84 files and need to be able to consolidate all of the tables per tab on each file.
Every file has the same tables but there are different tables on each tab in the files.
How do i select all individual tables for every file in the folder when i can't select more than one table at a time?
Sorry, my bad. Didn'T read your thread carefully.
If I understood you correctly, you can do the following:
Start with the table containing the overview of all files in the folder and add a column with this formula:
Excel.Workbook( [Content] ).
This will return the same table that I mentioned in my first post or each row. Expand it and filter the tables you're after.
This is a step in the right direction!
I just need to combine those tables now that all of the other tables have been filtered from each file so that the contents of the tables are diplayed through one query instead of seperate queries for each table.
Do you have any insight into this action?
I am trying to consolidate the 9 cover tables in the image below so that they are all able to be pulled and refreshed with 1 query.
Not sure I understand you correctly.
By now, you should just have one from-folder-query, right?
After you've expanded and filtered the new column, you should see all (the same) tables from different files in one table. Can't you just expand them?
You did everything right, I just missed the expand row values step.
Thank You Very Much! You have been tremendously helpful!