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 #222: Where There's a Whale There's a Way

MooHyung_Lee
6 - Meteoroid

Attached my solution

classyTeddy
8 - Asteroid

Thank you. Very interesting.

NBUSSER
7 - Meteor

challenge_222_start_file_Soluce

Arran
8 - Asteroid

Awesome

jdLearnAlteryx
6 - Meteoroid

Here is my solution!

Dhrish
8 - Asteroid

interesting how there are various ways to solve this

delosreyesjeric
7 - Meteor

This is my solution.

 

Whales.PNG

 

However, upon looking closely in the original source file, there seem to be no whales falling under Pod D0-C59 (Beluga) based on the output of the second Join tool. However, after the summarization tool, Pod D0-C59 appeared in the summary which I could not find out why it appeared suddenly and where did it came from. See below:

Summarize input showing no Pod D0-C59:

Summarize input_Whales.PNG

Summarize output showing Pod D0-C59:

Summarize output_Whales.PNG

 

Can you help me explain this?

 

RemiGCarre
5 - Atom

Great challenge - learned a few things with this one - how to round via the formula tool and the count of distinct value (got me on my first go - I was not counting distinct IDs but just doing an overall count). 

BS_THE_ANALYST
14 - Magnetar

Nice and quick.

SWilbur
7 - Meteor
Spoiler
Challenge #222.JPG