I have a challenge trying to deduplicate in the transforn and cleanse process.
Couple of question on this:-
What is the order of removing duplicates in transform and cleanse.
Is it from top top bottom or bottom to top or arbitrarly?
My issue is that I have loan numbers with mulitple records due to activities and task performed on the same loan number over time. I will want to remove the duplicates and keep the record with the most current completed task by date. In excel I will sort by New to Old and de-dupe. This keeps the most current date and removes the duplicates below . How can I achieve same with transform and cleanse feature.
Your help will be appreciated