We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit Feedback
For some reason I couldn't get my head around this challenge so here is my rather overcomplicated solution
:-) this is good stuff - we do this particular challenge all the time in real life!
Spoiler
- Bring in the new rows first into the union
- Add a record ID in-case some new rows have same info (e.g. Bob)
- Set the end-dates by using start date of the newer record
- Set the current flag using a unique tool taking only most recent
- Then remove people who have left completely (latest = y; but end-date exists)
- Bring in the new rows first into the union
- Add a record ID in-case some new rows have same info (e.g. Bob)
- Set the end-dates by using start date of the newer record
- Set the current flag using a unique tool taking only most recent
- Then remove people who have left completely (latest = y; but end-date exists)
