Every month I get an Excel file of retail locations. The retailer is always the same name, the Excel file is always formatted the same, and each retailer has a Unique ID. I want to join the previous month to the current month but flag when a new retail location opens and when a retail location closed. I would like to do this month over month to create a master retail list showing all historical locations: when they opened and when they closed.
I've been working on a join and then flagging the left and right joins as either "Opened Month/Year" and "Closed Month/Year". This works great for 2 months but not sustainable when I have files that go back several years. Manually recreating the workflow from the screenshot was taking a very long time. Also, I had to manually use a formula for the current month and year which added to the time to create a huge workflow. I tried to pull in the file name from the Input and then trim it to the month and year but that seemed to compound the problem when trying to join the end workflow to a new month. The "Opened" month/year didn't get populated after subsequent Unions.
Here is the closest I've gotten but can't figure out how to loop the flow to start from the beginning and work through all of the files. Ideally, I want the end of the workflow, after the Union, to go back up to the Left Input and have the Right Input change to the next month's file.
