Challenge #222: Where There's a Whale There's a Way

[MooHyung_Lee]

Attached my solution

[classyTeddy]

Thank you. Very interesting.

[NBUSSER]

challenge_222_start_file_Soluce

[Arran]

Awesome

[jdLearnAlteryx]

Here is my solution!

[Dhrish]

interesting how there are various ways to solve this

[delosreyesjeric]

This is my solution.

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 output showing Pod D0-C59:

Can you help me explain this?

[RemiGCarre]

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]

Nice and quick.

[SWilbur]

Spoiler