Forum Discussion
Extract Data from table with dynamic names
Hello, i have multiples excel files with data saved in a certain worksheet. The name of this worksheet is different in every Excel file, but the name of the worksheet always starts with "Data ". ...
Hi Anonymous ,
You should just be able to filter your name column, something like this:
Table.SelectRows(previousStepName, each Text.StartsWith([Name], "Data "))Then expand the [Data] column using the button at the top right that looks like two arrows bending away from each other.
Pete
Thank you!
How do i now open this table ? I usually click on the Table. Clicking it hardcodes the name, tough.
Pete