This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a project where I need to loop through sets of files based on their dates in a directory. Here's how my directory will look like.
First File 12-20-2021
Second File 12-19-2021
Third File 12-20-2021
Fourth File 12-20-2021
First File 12-14-2021
Second File 12-13-2021
Third File 12-14-2021
Fourth File 12-14-2021
First and Second files all have the same schema, Third and Fourth have different schemas.
I am thinking that I can use the directory tool to get all the First Files in the directory and then regex the dates. I would then need to loop through all of the dates and process the files in batches.I am not sure how to do this in the designer though. I would imagine I would have to feed the date to a macro that then goes to the directory and opens the first/second files and combines their data for processing? Then another macro would get the same date and open the third file for separate processing as well as for the Fourth file I guess I would need a different macro?
Sorry if this is confusing, I am trying to figure out how to process these four files together and then move on to the next set of files in the most efficient way possible. I'm new to macros 😞