Important notice: All Credly Certification exam badges that have been unclaimed for 30 or more days will expire on August 28, 2024. To keep your badges active, log in to your Credly account and claim your badge before the deadline. (Don’t worry, this does not affect your Community badges!)
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
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!
Saqueador
- 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)
