dynamic input to pull the last worksheet in an excel file?

Question

I have a workflow that produces a monthly excel file and every day it appends a worksheet. The worksheet names are dates so if I run the report today it will append a worksheet named yesterday's date.  I want to be able to pull this worksheet as input when I run the report again tomorrow so I can roll forward some of the amounts.  Is there any way to dynamically select the last worksheet in the file each day?

JagdeeshN · Answer

Hi @KateC ,

The combination of a formula tool and the dynamic input tool should do the trick for you.

Step 1:- Create the path to the file (with the latest date) within the formula tool.

Step2:- You can then use this field to replace the path dynamically within the Dynamic Input Tool.

Hope this helps point you in the right direction.

Best,

Jagdeesh