Assign values to duplicate items

I have below module that is update every few days

UID	Name	From Date
1	A1	17-Jan
2	B1	17-Jan
3	C1	17-Jan
4	D1	17-Jan

two records were updated when the next time(eff from) the job runs like below

UID	Name	From Date
1	A1	17-Jan
2	B1	17-Jan
3	C1	17-Jan
4	D1	17-Jan
5	A1	25-Jan
6	B1	25-Jan

I want to automatically stamp an end date to the prior value of the duplicate record so that the module looks like below

UID	Name	From Date	To Date
1	A1	17-Jan	24-Jan
2	B1	17-Jan	24-Jan
3	C1	17-Jan
4	D1	17-Jan
5	A1	25-Jan
6	B1	25-Jan

and then

UID	Name	From Date	To Date
1	A1	17-Jan	24-Jan
2	B1	17-Jan	24-Jan
3	C1	17-Jan
4	D1	17-Jan
5	A1	25-Jan	27-Jan
6	B1	25-Jan
7	A1	28-Jan

Appreciate any help with the most efficient way to solve. Thanks

Accepted answers

All comments

MarkWarren

Why are you bringing in duplicate records? This won't scale well; in this example, you have increased by 75% over 11 days…

yatin.ajbani

@MarkWarren

Hi Mark, sorry i should have been more clear. These are not exactly duplicates as they bring another unique trait along with the date when that record is updated. so we want to capture that change and stamp the to-date once a similar record comes. We do not bring all the records, but only the ones where that unique trait changed for the row. Also this exercise happens once every 6 months so we do not expect a lot of duplicate records in this module.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385