community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dynamic Input Excel Range

Meteor

I frequently specify a range of cells for the "Input" tool to import into my workflow, so I am surprised to find that the "Dynamic Input" tool throws up an error about not defining a sheet when I enter in a range. 

 

My scenario is that I have a directory folder where all the latest files arrive each month. I then choose the "LastWriteAccess" in the Sample tool, sort by descending and voila, I have the latest file. Then I feed it through a Dynamic Input but I want to pull in only certain ranges. Error occurs.

 

See my attached configuration. 

 

My question is this: Is the Dynamic Input tool capable of importing only the specific cells (A4:B150)? If not I'm open to other options though I'll likely need to rebuild. Thanks in advance!

Highlighted
Alteryx
Alteryx

Hi,

 

I think I've got it working, but you need to concatenate the FullPath (from the Directory tool) with the Sheet location in a Formula prior to supplying this to the Dynamic Input - does this work for you, if the specific cells remain consistent from load-to-load?

 

Cheers,

Nick

Nick Jewell | Alteryx Product Strategy
Alteryx
Alteryx

Also attaching the sample Excel file that I used.

 

N

Nick Jewell | Alteryx Product Strategy
Meteor

Excellent! Thanks a ton NickJ. 

Labels