Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #80: Slowly Changing Dimensions

Alteryx Certified Partner

Follow my solution attached...

8 - Asteroid

Such a cool challenge!

8 - Asteroid

Having implemented slowly changing dimension in other programs, Alteryx has made this quite simple.

Alteryx Partner

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. 

Alteryx Certified Partner

My solution:

Spoiler
challenge 80.jpg
Alteryx Certified Partner

Didn't want to use a join if we don't need one.

7 - Meteor

Are you generating surrogate keys?

8 - Asteroid

Here's my solution!

 

Spoiler
Challenge 80.jpg
17 - Castor
17 - Castor

A suitable Padewan challenge, this was.  No Fear, could I sense within it

 

Spoiler
Solution 80.png

 

yoDan

7 - Meteor
Spoiler
Untitled.png



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.

 

obiwan.jpg