Input File

johnrexrima_19

Hi,

I wanted to use a combination of Directory, Formula and Dynamic Input Tool to input a file with a variable file name. In the example below, the month-end date changes while the string "Realized GL Annual" is static. In the Directory tool, I used a wild card *Realized GL Annual* to locate the file with a preferred string. My problem would be in using the Formula Tool in specifying the sheet in the input file that I wanted to use coz the month-end date changes. Also, the file only has one sheet and the sheet name is the file name itself by default when it is downloaded.

Ex: Realized GL Annual 1.31.2020

Hoping to get your suggestions. Thank you!

DavidP

You would do it with 2 dynamic input tools, like this:

The directory tool loads the file name, you then us a formula tool to change the fullpath to load a list of sheet names, then replace <list of sheet names> with the actual sheet names and then load the sheet with the 2nd dynamic input tool

dynamic input.yxmd