I want to use Alteryx to append current month repurchase data (table) to prior period repurchase data (table). There could be a loan record in the current month data and that same loan record in the prior period data. I need to append the current month data to the prior period data, but need to keep both records. They both need to be tagged as duplicates and the older record needs to have a date put in it. These would be already existing columns that would need the update. Below is the example of what I need it to look like, note that this example is note showing all the columns for each record.
