Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
Bold Text Example

The localized versions of the Core Certification will be discontinued on September 22, 2023. To take the exam in your preferred language, please schedule it before this date. The Core exam will still be available in English at any time after September 22, 2023. If future versions of the Core Certification exam are localized, we will promptly announce their release dates.

alteryx Community

# 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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #286: Who turned the lights off?

12 - Quasar

My solution:

Spoiler

8 - Asteroid

Spoiler

I made my approach ensure that only Operatives with Animal were replaced. I saw that some Null()'s came up when using a different method. My thought process was, assume operatives that were != "Animal" are already correct. I didn't want to make the assumption that the "Article" tag included the correct operative, or even the possibility of a different (or multiple) operative(s). I guess someone could make the argument that Operatives != "Animal" could also be potentially incorrect. Unclear data would obviously lead to questions to determine the actual correct approach.

But with a safe dataset like this, the above was probably over thinking the exercise 😉

11 - Bolide

Funny challenge after some break of using Alteryx 🙂

Spoiler

Karolina

11 - Bolide
Spoiler

Cool!

6 - Meteoroid

Such a fun challenge.

7 - Meteor

15 - Aurora

Funny challenge !

Spoiler

13 - Pulsar

First one in years 🙂

Spoiler

Joe Lipski
5 - Atom

Great fun exercise !!

11 - Bolide
Spoiler
those pesky plural forms required extra work! ended up not with a very dynamic approach, but it covers typical plural forms (with -es and -s endings)