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?

phottovy
12 - Quasar

My solution:

 

Spoiler
286.png

 

PeteLacz
6 - Meteoroid

 

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
8 - Asteroid
Spoiler
TimN_1-1632262941137.png

 

Cool!

Smrithi
6 - Meteoroid

Such a fun challenge. 

WSDATA
5 - Atom

WSDATA_0-1632320239861.png

 

messi007
13 - Pulsar

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
10 - Fireball
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