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

JustinBabbitt
Alteryx
Alteryx

My first time attempting the challenge! Thanks!

Justin Babbitt
PhilipMannering
16 - Nebula
16 - Nebula

Similar to most peoples in concept... 

I'm assuming the output order is unimportant.

Spoiler
WC80.png
EmanueleE
8 - Asteroid

Here my Solution!!!

 

Spoiler
SPOILER!!!

1.PNG

vishalgupta
7 - Meteor
 
Natasha
9 - Comet

For some reason I couldn't get my head around this challenge so here is my rather overcomplicated solution

Spoiler
Screen Shot 2017-10-05 at 00.45.53.png
SeanAdams
17 - Castor
17 - Castor

:-) this is good stuff - we do this particular challenge all the time in real life!

 

 

Spoiler

- Bring in the new rows first into the union
- Add a record ID in-case some new rows have same info (e.g. Bob)
- Set the end-dates by using start date of the newer record
- Set the current flag using a unique tool taking only most recent
- Then remove people who have left completely (latest = y; but end-date exists)


2017-10-08_21-59-35.png



 

LordNeilLord
15 - Aurora

Solution

Spoiler
Weekly Challenge 80.png
estherb47
15 - Aurora
15 - Aurora

Odd that my solution didn't post in the week of this challenge, but here it is.

LandonG
8 - Asteroid

Went a little overboard on this one. Fun challenge!

ggruccio
ACE Emeritus
ACE Emeritus

Fairly straightforward data manipulation