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

My Solution:

This was a fun one.

Challenge 120 2019-12-04.jpg

I did it! Looking at everyone else's solutions, it seems like i need to get over myself and learn regular expressions. Here we go.

7 tools, but seems like I can definitely simplify this...

fun exercise..

text to columns tool on Field 1, formula to get year out of file link. Then I used some joins and summarize tools to calculate the highest for each year. Also cache'd the original names data set so the workflow wouldn't take forever each time.

text to columns tool on Field 1, formula to get year out of file link. Then I used some joins and summarize tools to calculate the highest for each year. Also cache'd the original names data set so the workflow wouldn't take forever each time.

Solved!

Below is my solution

curated machine learning resources