Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Follow my solution attached...
Such a cool challenge!
Having implemented slowly changing dimension in other programs, Alteryx has made this quite simple.
Got a bit stuck on this one so had a sneaky peek to help me out! Good exercise and learnt how to handle some new things such as if people/customers are current or not.
Didn't want to use a join if we don't need one.
Are you generating surrogate keys?
Here's my solution!
A suitable Padewan challenge, this was. No Fear, could I sense within it
I must be complicating issues...Will take a look at what others do.
Also, there seems to be a discrepancy here. In the solution provided inside start file, Bob's record is erased from archieve, but in the solution file, it is retained with a current flag of Y.