duplicate record tagging

[lporter1970]

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.

[davidskaife]

Hi @lporter1970 

There are a few ways to do this, but please find below one example:

I've attached the workflow for you to have a look at and hopefully use the logic/methodology in your workflow and change accordingly to fit your needs :)

[digitalmemo]

i did a slightly different approach and utilized Only Unique tool and Summarize MIN