Is there a component option that will allow the FlatFileReader to locate a file in a directory with the most recent create (or update) date? For example the directory I am reading from contains 4 files and new files will be added as dictated by the the business. I only care about reading the latest dated file that starts with the name test_. I know a * is a wild card but I haven't seen any documentation on how to find the file name with the newest create date. Do I need to use the ListFiles component to first read the directory and then parse each file's metadata to find my target file name?
Example directory: (I need to read file test_3.csv based off the criteria that its name starts with "test_" and it has the latest create date.)
test_1.csv file create date 2022-12-05
test_2.csv file create date 2022-12-13
test_3.csv file create date 2022-12-17
prod_A.csv file create date 2022-12-20
Please sign in to leave a comment.