@Hamster As long as the names remain unchanged, we do something like this.
1. Retrieve the Excel File list by Input Data tool
2. Text input for Names of Named Range
3. Formula Too to get full path
4. Dynamic Input to pull out the data with the full path.
If you need, I can make a sample workflow.
Hi,
By any chance can you send us over a data sample and the desired output?
@Hamster Alteryx can pull out the sheets name, but not the named range.But if you have the list of the named ranges, there might be something we can do.
The named ranges will change as the rows change so anything hard coded will not work.
