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.
Use the Union Tool to combine the two files, then the Sort Tool (sort by ID ascending, modified date descending), then the Summarize Tool (group by ID, Name = First, Gender = First, Last Modified Date = First)
If your input file names change each day, you may need a batch macro for a fully automated solution.