Challenge #80: Slowly Changing Dimensions

[hannahc]

Here is my solution! Like a few others, my Richard records are out of order vs the output provided, but all there.

 

[Tokimatsu]

Solved.

Spoiler

 

[OnionKnight]

Fun!!

[Sashikumar]

Solved.

Spoiler

[clmc9601]

My solution

[JP_SDAK]

I had a Slowly Changing Comprehension when trying to understand why Bob dropped out ...  @NicoleJohnson  and @MarqueeCrew helped with that (I was originally including the Join connector; seeing it called terminated helped turned the light on 🤔)

Spoiler

[apathetichell]

A meandering mess of multi-row formulas... Not sure about the sample output as there's a 10 month gap between Richard's Jedi Knight end date and his first day as a Jedi Master. Is this some kind of Jedi spiritual journey to the VHS tapes of the original series?

[mpennington]

Solution attached.

Spoiler

[rcarog]

Solution attached.

[Chantelb]

Spoiler