Dynamic Input based on Months

sanketkatoch05

I'm trying to use a dynamic input tool wherein the Alteryx should select a file based on current month, i.e. 

if the current month is 'Feb' then select the file - 'Feb - 3'

if the current month is 'Mar' then select the file - 'Mar - 4'

If the current month is 'Jun' then select the file - 'Jun - 4'

The trivia here is that only the Feb month's file has '3' in it, else all the months contain 4. 

mceleavey

Hi @sanketkatoch05 ,

You need to read in the list of files using the Directory tool, then build a formula to determine the current month in that format, then filter the records based on those that contain this date string before feeding into a Dynamic Input tool.

I've attached a workflow with some tools I wrote to do this. Simply re-point your directory tool to the folder you're using.

You might need to change the formula slightly, but this does what you want.

Hope this helps,

M.

mceleavey solution.yxzp