Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

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 #274: Concattributes

achillesjing
7 - Meteor

Here is my solution.

alexnajm
18 - Pollux
18 - Pollux

Nice and simple to start the week 😊

Spoiler
challenge_274_start_file_Alex Abi-Najm.PNG
CandiceDB
Alteryx Alumni (Retired)

My solution, but my results do not match the Output file provided which has the "Vision - %" Powers included in the Measurements instead of as Powers. Reading the brief, I chose to leave my results with "Vision - %" as Powers:

 

Spoiler
CandiceDB_0-1624911013617.png

 

 

TonyA
Alteryx Alumni (Retired)

So all the measurement columns are numeric and are grouped together except for Vision, which is categorical and scattered among the powers. Funny that a challenge about super-heroes turns out to be typical of the real world. How often do you get written specifications for a project that don't account for special cases or unexpected interpretations? That's why sample outputs help (although they still don't always include all the special cases).

Spoiler
TonyA_0-1624918291477.png

 

KaneG
Alteryx Alumni (Retired)

Nice quick one... naturally dynamic though!

 

Spoiler
KaneG_0-1624940270813.png

 

Shapna74
7 - Meteor

This is my first weekly challenge solution!

Spoiler
weekly challenge 274.JPG
JLdG
6 - Meteoroid

Not dynamic but good refresher on summarize tool

 

Spoiler
JLdG_0-1624952625255.png

 

JLdG
6 - Meteoroid

I think I might be on a different version of Alteryx, what is that equal sign operator in your workflow?

 

From the flow it looks like it can cross validate an output?

 

Thanks!

JL

sukanya_T_P
6 - Meteoroid

This is my solution

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar
Spoiler
キャプチャ.JPG