I am merging two collections with the same number of fields "date, requested1, requested2, requested3". In the merged collection there are some repeat dates, I only want to show each date one time. I thought that merge would automatically handle this and show the second date of the duplicate pair, but that isn't happening.
Is there any way to remove duplicates aside from unique? I tried that but it removes the duplicate and keeps the original, but I want to remove the original and keep the duplicate.