Can someone help me help me create workflow to pick most recent file and top3 most recent

Question

I want to pick up latest file and top 3 latest file from folder. I've 7 files in folder few starting with aaaaaa and few with aaabbb. How can I pick up file starting with aaabbb and most recent file and top 3 files from folder? In case there is a new file with name aaabb_2022_11_15 and aaabbb_2022_11_15 in the folder then I want to pick up aaabbb_2022_11_15 also the user should be able to select any specific file using analytic app example user should be able to pick aaabbb_2022_11_12 even if its not most recent.

Can we filter right filename by using regex and filter?

Note - default mechanism is to pick most recent file with name aaabbb and also have ability to take specific date from user when run as analytic app

how to pick specific sheet from multiple sheets in excel file?

I also attached excel files here. i want to get data in sheet A. Can someone help? Thank you

aaaaaa_2022_11_14.xlsx

aaabbb_2022_11_12.xlsx

aaabbb_2022_11_13.xlsx

aaabbb_2022_11_14.xlsx

aaabbb_2022_11_18.xlsx

KrishnaChithrathil · Answer

@srk0609 hey. sorry I wasn't active this week. Is this issue resolved? Attaching what I've tried.

create workflow to pick most recent file and top3 most recent.yxmd

ArtApa · Answer

Hi @srk0609 - Here is a useful article for you: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220

srk0609 · Answer

Hi the workflow worked partially I was able to pick top 3 most recent files but can you please help me read those files? I'm getting following error when I try to read using Dynamic input tool. My xlsx file contains multiple sheet can you please tell me how to add sheet name to Dynamic input tool?