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

[srk0609]

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

[KrishnaChithrathil]

@srk0609 

Does this help you anyway?

sorted the filename and creation time.

[srk0609]

Instead of creation time I want to use the date mentioned on the file name. Can you please tell how to do that?

[KrishnaChithrathil]

@srk0609 

I took the date from the file name and sorted. How does this look?

[srk0609]

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?

[ArtApa]

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

[KrishnaChithrathil]

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