A solution to last week's challenge can be found here.
Using the values in the attached file "womens_world_cup_data.txt", determine which team won the most matches.
Go Team USA!
Quick challenge to break up the work day!
Finished this one quickly!
Simple
Quick and fun challenge! Tried to use as few tools as possible, some cool solutions.
I thought home goals played into tie breakers? But I also don't understand soccer scoring.
My solution
here's my solution to the World cup question.
I love using @jdunkerley79's VarNum and VarText functions that he added in v1.4 of his alteryx abacus tools. The formula tool looks a little verbose when you get done, but they're easy to work with while building.
My solutions:
Leveraged the summarize tool twice - first to group wins by team, and second to figure out the max wins and join back to the wins by team summary. In this case, you get the same answer as a summarize, sort desc, and sample tool, but that wouldn't be the case if multiple teams tied for the most wins.
here's my solution
Here's my solution
Easy one this week.
Here's a slightly more outside the box approach.
Quick wins! Keep it simple.
Thanks for posting these every week!
Pretty quick challenge
This is usually the case for knockout phases of club tournaments, but it is hardly ever the case for international matches.
My answer attached below, great challenge!
I couldn't leave it without visualizing the data and I couldn't handle the wrong Lionesses on top by wins. By win percentage #KNVB takes the rightful top spot. #Oranje
awesome thank you
Just realized I posted the solution to last week's challenge instead of this week's. Here's the correct solution.
Good point
Hi @Kenda, what is this tool you're using to compare the workflow output to the solution output? I've been using join tools for this and sometimes having to join by more fields than I'd like to admit. This looks like it might be a more automatic way.
Not too bad!
Spoiler
Brilliant indeed!
I went through lot of different approaches then realized two things - Tie and It's in the formula then Summarize. 3 major steps to close this assignment.
Thanks for sharing your knowledge.
Regards,
Pratik
sneaky little tie case
Please find the solution which I built and guide me is this fine to build
Go Team USA!
