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

8 - Asteroid

My solution below:

 

Spoiler
Łukasz_0-1600930308318.png

 

15 - Aurora

Had difficulty in understanding the real point here.

Spoiler
en-80.PNG
Alteryx
Alteryx

I prefer to do this with Joins rather than Multi-Row, as in practice some of the decisions are often pushed to the DB using In-DB tools

 

Spoiler
I didn't like discarding Bob... but I did in order to match the output

KaneG_0-1603850750913.png

 

10 - Fireball
Spoiler
Capture d’écran, le 2020-11-02 à 15.46.00.png
Alteryx Partner
Spoiler
Please see my solution below. 
9 - Comet

Not my most elegant solution but it works

Spoiler
Img 80.png

 

8 - Asteroid

My Solution!!

8 - Asteroid

Here's my attempt

8 - Asteroid

Mine feels simpler than the others.  Not sure if that is a bad or good thing.

 

Spoiler
tammybrown_tds_0-1609141583761.png

 

8 - Asteroid
Spoiler
workflow.png

Here is my submission for challenge 80, use multi-row formula tool many times.😂