Pick input file by month through Dynamic Input tool

Question

Hello,

i have a folder that listed all input excel file(.xlsx) and out of that list there is a file name by first three letters of month such as - Jan, Feb, Mar, Apr.... . in every month business will replace that folder with their current month and because of that replacing file name for that month will change. for example - in January there will be file name as Jan and in next month when they will replacing all files that file name will change to Feb and Mar, Apr....

how can i use Dynamic Input tool to pick that specific file with month name (Jan for January, Feb for February.......)

Yoshiro_Fujimori · Answer

Not sure I fully understand your situation, but you may try to tweak the expression in Filter tool to meet the naming rule of your input file.

e.g.

[FileName] = 
DateTimeFormat(DateTimeAdd(DateTimeToday(),-2,"month"),"%b") + "_" + 
DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,"month"),"%b") + ".xlsx"

Good luck.

kauser · Answer

@Yoshiro_Fujimori

Thanks for your reply. its working nice but issue is it picked only current month file but input files for this workflow will be from previous or month before. for example in august all input files will be from June/July and that file name will be Jun/Jul.xlsx. Also, in that input folder there will be only one file that will name with first three letters from month and rest of files will be have individual name.

Yoshiro_Fujimori · Answer

@kauser ,

Here is one way to do this;

* Get Full Path with Directory Tool
* Filter the output by the month (Jan, Feb, Mar, ...) of today's date with the expression;
StartsWith([FileName], DateTimeFormat(DateTimeToday(),"%b"))
* Pass the Full Path to Dynamic Input

I hope this helps.

DynamicInputWithMonth.yxmd