Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #1: Join to Range

steven4320555
8 - Asteroid
Spoiler

 

steven4320555_0-1585749434006.png

 

My first weekly challenge. Not as straight forward as I have thought. Good to practice something during the covid-19 stay at home period. I hope to do more, and catch up.

TSP
8 - Asteroid

Finally getting round to doing the challenges. Starting from the beginning...

 

Spoiler
SPOILER

challenge_1_TP_screenshot.PNG
Evgeny
7 - Meteor

Challenge completed,

KInd regards,

 

Spoiler
Evgeny_0-1586005265307.png

 

 

atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges
Adrenaline rush

 

Spoiler
This is my solution

atcodedog05_0-1586106185409.png

 

I had solved it previously, seems like i forgot to post my answer. Posting again now 🙂

andresleonm
7 - Meteor

Here is my solution 🙂

Sonya_15
5 - Atom

Completed

AbhilashR
15 - Aurora
15 - Aurora

Challenge #1

KevinTang
8 - Asteroid

done

mark007
8 - Asteroid

Done 🙂

Nataly_Kelly
5 - Atom

I completed the challenge, but I used "find replace" instead of a "join" since I learned the tool yesterday and wanted to practice. Learned the "find replace" tool only finds strings, while the "join" can work with any integer.

I also added validation to make sure that I received the same results as the output. However, I'm very new to Alteryx and my solution is very cumbersome. I'm sure I'm missing a simple validation tool. Does anyone have a less clunky solution that will return the table that I show at the end?