Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Challenge #80: Slowly Changing Dimensions

njsteengaard
6 - Meteoroid

Hereby my solution 🙂 

rslopez2
8 - Asteroid

Can we expect to See Bob in the next generation of  Villains!?

 

Spoiler
RL_WK 80Solution.png
RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_80_RODO_Solution.png
jagdeep_singh85
8 - Asteroid

PFA my solution

SueDonim
8 - Asteroid

Had a little trouble with the deletion of a person (I'm just too nice to randomly off someone).  I suspect that part could be more efficient.  But it works

 

Spoiler
Process
- Filter out person from Today's Updates if they do not have an End Date
- Union data together
- Sort by Start Datre
- Update End Date to equal any subsequent Start Date (to indicate a promotion)
- Current Flag reset to equal "N" if there is an End Date (i.e. there must be a new Start Date, so no longer current)
  -- Actually this leaves Bob's old data as showing as current - so this is less than ideal (even though I clean that up in the next steps), as it could create an error elsewhere in the workflow if not careful
- Union data with anyone filtered out in Today's Updatge
- Create a "Deleted" field if Current Flag is null
- Update "Deleted" field to all instances of that person
- Filter out Deleted records
- Cleanup and sort

MySolution.PNG
justindavis
10 - Fireball
Spoiler
challenge_80_solution_justindavis.PNG
meeravijayan2011
8 - Asteroid
Spoiler
SPOILER
80.png
bjkay30
8 - Asteroid

Here is my solution.  Could have been done using less tools, but tried to keep it dynamic so that the list could be updated again, and anyone else converting to the dark side would be filtered out.

 

Spoiler
bjkay30_0-1574173432330.png
sarahjohnson
8 - Asteroid
Spoiler
sarahjohnson_0-1575924258503.png
sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1576080529661.png