This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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?