Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #80: Slowly Changing Dimensions

Highlighted
Meteoroid

Hereby my solution  

Highlighted
Asteroid

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

 

Spoiler
RL_WK 80Solution.png
Highlighted
Alteryx Partner

My solution

 

Spoiler
challenge_80_RODO_Solution.png
Asteroid

PFA my solution

Highlighted
Alteryx Partner

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
Highlighted
Asteroid
Spoiler
challenge_80_solution_justindavis.PNG
Highlighted
Alteryx Partner
Spoiler
SPOILER
80.png
Highlighted
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
Highlighted
Asteroid
Spoiler
sarahjohnson_0-1575924258503.png
Highlighted
Spoiler
sonyakasenkramer_0-1576080529661.png