How to pick latest month name tab in a excel.

[SudhaGupta1]

Hi All,

I have a file that has multiple tabs. Every month new tab is add with last month name. i;e; January, February, March etc. I want workflow to read the last month tab. How can I do that?

[aatalai]

@SudhaGupta1 

Import the sheet names and use a filter with   datetimeformat(datetimenow(),"%B")=[sheetname] and then use a dynamic input tool to read that sheet. This is assuming constant scheme and that the current month is the most recent month 

Let me know how you get on

[BS_THE_ANALYST]

@aatalai be mindful here as your proposed method also assumes hidden tabs won't be in:

Potential block for people who hide working tabs. I think you can address this though by unzipping the workbook and looking in the attributes for "hidden". Can parse out the hidden tabs in Alteryx or Python and then remove them from the list of sheet names:

All the best,

BS

[SudhaGupta1]

Thank you @aatalai ,

Just missed to add latest month is last month.

[binuacs]

@SudhaGupta1 sample workflow attached