Weekly Challenges

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.

SUBMIT YOUR IDEA

Challenge #286: Who turned the lights off?

phottovy
13 - Pulsar
13 - Pulsar

My solution:

 

Spoiler
286.png

 

PeteLacz
8 - Asteroid

 

Spoiler
PeteLacz_0-1632236678130.png

 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 😉

KarolinaRoza
11 - Bolide

Funny challenge after some break of using Alteryx 🙂

 

Spoiler
KarolinaRoza_0-1632254017901.png

 

Karolina

TimN
13 - Pulsar
Spoiler
TimN_1-1632262941137.png

 

Cool!

Smrithi
6 - Meteoroid

Such a fun challenge. 

WSDATA
7 - Meteor

WSDATA_0-1632320239861.png

 

messi007
15 - Aurora
15 - Aurora

Funny challenge !

 

Spoiler
messi007_0-1632321961699.png

 

Joe_Lipski
13 - Pulsar
13 - Pulsar

First one in years 🙂

 

Spoiler
Joe_Lipski_0-1632322022930.png

 

Joe Lipski
AnkitVerma
5 - Atom

Great fun exercise !! 

hanykowska
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)

hanykowska_0-1632329290788.png