community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #80: Slowly Changing Dimensions

Alteryx Certified Partner

Follow my solution attached...

Asteroid

Such a cool challenge!

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.

Meteor

Are you generating surrogate keys?

Asteroid

Here's my solution!

 

Spoiler
Challenge 80.jpg
Nebula

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

 

Spoiler
Solution 80.png

 

yoDan

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