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.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #308: Size it up

MarqueeCrew
19 - Altair
19 - Altair

Here's a challenge solution.

 

Spoiler
I didn't like the division by total input rather than by good data.
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
kunderwood
8 - Asteroid

RegEx expressions are one of my favorite things to do. Good parsing challenge. 

Spoiler
kunderwood_0-1646072649565.png

 

TonyA
Alteryx Alumni (Retired)

Followed the directions and got a different result. 

Spoiler
We were told to eliminate incomplete data so there should be 1845 rows, not 1850. The solution shows 1850.
TonyA_0-1646072739792.png

 

MatthewBr
Alteryx
Alteryx
Spoiler
Love it - simple parse and prep
DavidSkaife
11 - Bolide

Here's my solution!

 

Spoiler
DavidSkaife_0-1646079633209.png

 

mmotte628
7 - Meteor
Spoiler
308-1.PNG
ALTSkelly
7 - Meteor
Spoiler
ALTSkelly_0-1646084554883.png
Spoiler
 
TurboToad
7 - Meteor

My solution, had to look at the source data to figure out how to separate some of the values. 

 

Spoiler
TurboToad_0-1646086820959.png

 

Reesetrain2
8 - Asteroid

All,

 

Spoiler
I'm not really sure what happened as with the 1850 Total entries, I ended up with 286 Large amongst some other small differences.
-I used the Count tool & Append Field Tool, Text To Column, 2 Formula Tools.
-I always attempt to complete every challenge without the use of custom code, so no Regex for me.


-Capture.PNG

KarenYL
8 - Asteroid
Spoiler
Screenshot 2022-02-28 173820.png