How to read multiple files with same prefix loop each files process load in to database

[narenderm]

I am looking for an option to read file prefix pattern from source directory and loop same process for each file to load into database table.

For eg.

source directory:

filename_20211004

filename_20211005

filename_20211006

workflow should pickup filename_20211004 reach and load into database table and then it should pickup next file and so on.

Files should process in sequence order base on date on file name.

Please suggest how to achieve this implementation.

[messi007]

@narenderm,

Please check this post : https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Fi... 

He explain how you can do it step by step.

Hope this helps,

Regards,