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.
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.
You did everything right, I just missed the expand row values step.
Thank You Very Much! You have been tremendously helpful!