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 #268: Definitely Not Made Up

martinding
13 - Pulsar
Spoiler
268.png

Jodelgado518
6 - Meteoroid

My Solution

daiphuongngo
9 - Comet

Challenge #268 Definitely Not Made Up.jpg

gautiergodard
13 - Pulsar

solution

DataNath
17 - Castor
17 - Castor

Here's my solution to #268.

 

Spoiler
DataNath_0-1667737292150.png
karlhansen
9 - Comet
Spoiler
solution_268.jpg

Oh, I dropped any record that had a null value, not realizing that the columns themselves could properly be of different lengths.  Will reply with a new workflow. 

 

karlhansen
9 - Comet
Spoiler
solution_268.2.jpg

Here is the replacement.

gerda
8 - Asteroid

 

Spoiler
challenge 268.png

Here's the solution!

 

RWvanLeeuwen
11 - Bolide

My take allows to retain some context in the data as I...

Spoiler
randomly rename cities and clients. My approach breaks the association between the client and city but rows with the same client, city combination will be recognisable afterwards still - this would be similar to a pseudonymisation approach and I deem this to be the most relevant approach
268.png
SkomantasTamulaitis
8 - Asteroid

Here's my solution.

Spoiler
Screenshot 2022-12-09 121448.png