Dynamic Input

[Kinetic_analytics]

Hello:

Usually this is the file format. Aug31-Sep23 FV_FX.xls. I do not know exact what date range would be in the next months file name. In that case how could I dynamically input the file in my workflow? So that next time I do not need to open the workflow and fix it. What would be the smart solution to handle it. 

Appreciate your help

Thanks

[OllieClarke · Accepted solution]

@Kinetic_analytics if the file is always in the same directory, you can use a directory input tool, sort by file creation date, sample to the top 1 and then feed a dynamic input tool.

That would always read in the latest file in that directory.

If you want to read in multiple versions of the file, then simply remove the sample tool.

Hope that helps,

Ollie

[Kinetic_analytics]

@OllieClarke Thank you. Great help.