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.

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 #338: Let's Summarize!

FrederikE
11 - Bolide
Spoiler
FrederikE_0-1664609057617.png

 

SylwiaDragon
8 - Asteroid

done

tammybrown_tds
8 - Asteroid

I figured out why some solvers are getting different answers than the provided solution.

 

If you use a Parse tool to extract the "year" of the release date, you won't get any "null" values in the year column.  So that makes the comment about ignoring null values irrelevant.  If you use the Text to Columns tool to extract the year of the release date, then you will, because not all of the release dates are in the same format (i.e, 27 Oct 1973, vs. October 1973 vs. 1973).  The second and third option will put the year into the second or first column in the Text to Column field and it will give a null value in the third column, so that row gets filtered out on null values.  

 

Using a Parse tool and REGEX to get the 4-digit year keeps all of the records into the rest of the workflow.  Doing this will result in different answer than the provided one/the solution.

 

Spoiler
tammybrown_tds_0-1664826675984.png

 

Shelbey
8 - Asteroid
Spoiler
Shelbey_0-1664832146172.png

 

KelleyS
Alteryx
Alteryx
Spoiler
KelleyS_0-1664833083719.png

 

Kelley Sinnock
Strategic Customer Success Manager
Alteryx
martinding
11 - Bolide

A very nice application of the Summarize tool!

bhairavi
7 - Meteor
Spoiler
bhairavi_0-1664870267500.png

 

GabrielaTudor
8 - Asteroid
Spoiler
GabrielaTudor_0-1664890123072.png

 

karlhansen
8 - Asteroid
Spoiler
solution_338.jpg
amjadmanasra
8 - Asteroid

my solution

I liked the way the submitter solution handled date format more, but never the less , this is how I did it