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 #224: Mushroom for Improvement

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

my solution 

Highlighted
Alteryx Certified Partner

solution attached.

Highlighted
8 - Asteroid
Spoiler
tiffanyshaw_0-1595388151060.png
Highlighted
8 - Asteroid

Here is my solution

Highlighted
8 - Asteroid

I think it's not the most elegant solution, but enjoyed it anyway!

 

Spoiler
hanykowska_0-1595434742245.png

 

Highlighted
8 - Asteroid
Spoiler
Capture224.JPG

 

This took some thought.but finally got it !

Highlighted
8 - Asteroid
Spoiler
jonathangonzales_0-1595512687047.png

 

Highlighted
7 - Meteor

My Response

 

Spoiler
naresh5315_0-1595568206237.png

 

Highlighted
8 - Asteroid

Another challenge of the week~

Highlighted
Alteryx Certified Partner

Here is my submission

Spoiler
I took a peek at some of the other solutions, and also the "official" since it was available.

It seems that I took a different approach, and instead of pivoting and joining the data, I used the Dynamic Replace.

I will admit, it is a bit tricky, but IMHO it think it was more suited here
2020-07-24 11_33_46-Window.png

 If you would like to know more on the Dynamic Replace Tool, I can recommend the Tool Mastery | Dynamic Replace page

Since I did not pivot the data, I had to ad a final replace of the column names that contained the - instead of the _ in order to match the provided result

On the lookout for a selfie stick
/Verakso