Forum Discussion
Select Multiple Tables when data is retrieved from folders
I am trying to run a query for all tables in multiple workbooks that exist in a single folder, but I can only select one table in the list at a time when connecting at the folder-level.
I am trying to connect to tables : Cover_Table001 thru Cover_Table009.
How do i select each table without selecting the entire sheet?
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.
6 Replies
Select one file and delete all automatically generated steps but the first one.
This will return a table with all objects in the Excel-file from which you can select those you need and then expand them all at once.
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.