Can Alteryx input excel dynamic named range

[Hamster]

I have a workbook of say 3 tabs each tab has a dynamic named range that I need to pull into Alteryx

[Emil_Kos]

Hi,

By any chance can you send us over a data sample and the desired output? 

[Qiu]

@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.

[Hamster]

The named ranges will change as the rows change so anything hard coded will not work.

[Qiu]

@Hamster 
Even the name of the named range?

[Hamster]

No, the range will expand and contract based on the columns and rows but the name will stay the same.

[mceleavey]

Hi @Hamster ,

If you can determine the range using logic then you can wrap the dynamic input in a macro and feed in the columns and rows and rows as dynamic values to overwrite the range. However, you would need to load in the sheet to determine the range, which in my mind makes it pointless as you would simply load in the entire sheet and select the range of cells that are required based on population.

You could also wrap the whole thing in an app and have the user input the range, which would then overwrite the range in the input tool.  It's not dynamic as such, but would allow the user to define the range on each run. Given the source is external it's impossible for Alteryx to know the range until you define it.

If you have a named range in the sheet, then you can instruct Alteryx to load in the named range, which will expand and retract accordingly.

M.

[Qiu · Accepted solution]

@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.

[Hamster]

Thanks I'll take a look at your suggestion.