This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
2022.1.1.30569 Patch Release Update
The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs.
If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.
Several problems with the provided solution. As @Reesetrain2 noted, Bronx is a borough of New York City. Also, the solution doesn't account for cities that have more than one team in the same league. So New York should be in the list. Excluding the Bronx, it has no NFL or MLS teams but does have two NHL and NBA teams. The question asks how many leagues are represented. The solutions shows a count of 5, should be 3.
I created 2 outputs. One has the 48 cities, but outlines each of the Team types and names them. the other has 101 records but that's due to each of the cities having multiple teams. I also kept the Burroughs of NYC separated.
I used my first macro, that was fun, Also noticed solution was wrong, because New York City has 5 teams but only 3 leagues. I made sure to include the extra teams in the final data, but only count them as 3 unique leagues