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.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #286: Who turned the lights off?

ArtApa
Alteryx
Alteryx

Here is my solution:

Spoiler
ArtApa_0-1633063295930.png

 

kmickelson
8 - Asteroid
Spoiler
Spoilerkmickelson_0-1633113447146.png

Uploaded my solution.

Kanishkas5301
8 - Asteroid

Interesting

nikastar
6 - Meteoroid

Done!

Spoiler
Screenshot 2021-10-04 121150.png
cframos
7 - Meteor
Spoiler
cframos_0-1633361706977.png

 

CandiceDB
Alteryx
Alteryx

My solution:

 

Spoiler
CandiceDB_0-1633457345266.png

 

chukleswk
7 - Meteor

Here is my solution:

Spoiler
Spoiler:
Capture.JPG

MuralidharAreti
6 - Meteoroid

Working my way down the line to try and cover them all! Here is my solution: 

 

Spoiler
MuralidharAreti_0-1633560868808.png

 

AlexvanOs
8 - Asteroid

I chose the non-union way and fixed the animal naming issue that kindly enough didn't effect the outcome, but still bothered me:

Spoiler
Bobcat, Caterpillar and Cat are three entirely different animals, but all three contain the string 'cat' when case insensitive F/R is implemented. So I had to work my way around that one by using some spaces & reverting it later. That kind of forced me to the formula way instead of the union way:
Challenge 286 solution.png

My way of Solving the Problem