Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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