Dynamic input file

[omkarshinde]

my sheet name changes daily with combination of previous date

and i want to input it dynamically in Alteryx, will I need regex for this or dynamic tool?
any help is appreciated!

[aatalai]

Look at setting up a standard macro, with an action tool updating the sheet name based on date using a formula. @omkarshinde let me know if this helps/if you would like some further guidance

[binuacs · Accepted solution]

@omkarshinde use the filter tool to get the sheet name with previous date and use the dynamic input tool to extract the data