Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #80: Slowly Changing Dimensions

daniel_ferreira
8 - Asteroid
‎04-27-2018 04:57 PM

Follow my solution attached...

challenge_80_solved.yxmd
Reply
0 Likes
jwlong91
8 - Asteroid
‎04-30-2018 05:24 AM

Such a cool challenge!

challenge_80_solution_JWL.yxmd
Reply
0 Likes
JonM
8 - Asteroid
‎05-31-2018 04:18 PM

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

challenge_80_JonM.yxmd
Reply
0 Likes
Tom_Pilgrem
8 - Asteroid
‎06-07-2018 08:35 AM

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. 

challenge_80_TP.yxmd
Reply
0 Likes
Wouter
8 - Asteroid
‎07-10-2018 06:03 AM

My solution:

Spoiler
challenge 80.jpg
challenge_80_solution_WK.yxmd
Reply
0 Likes
Ruud
10 - Fireball
‎07-11-2018 03:28 AM

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

challenge_80_ruud.yxmd
Reply
0 Likes
akshatoz
7 - Meteor
‎07-13-2018 12:47 PM

Are you generating surrogate keys?

Reply
0 Likes
StevenBetts
8 - Asteroid
‎07-18-2018 03:22 AM

Here's my solution!

 

Spoiler
Challenge 80.jpg
challenge_80_start_file_SMB.yxmd
Reply
0 Likes
danilang
19 - Altair
19 - Altair
‎08-09-2018 10:06 AM

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

 

Spoiler
Solution 80.png

 

yoDan

challenge_80_solution_DL.yxmd
Reply
0 Likes
Aster
7 - Meteor
‎08-19-2018 12:10 AM
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

 

challenge_80_start_file - Aster.yxmd
Reply
0 Likes