Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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 #366: Three Columns Are a Crowd

ggruccio
ACE Emeritus
ACE Emeritus
‎04-10-2023 09:46 AM

Made me think for a minute!

 

Spoiler
Used Transpose, Filter, Summarize (Concatenate) then just a matter of formatting.
ggruccio_0-1681145200031.png

 

challenge_366_gg_finish.yxzp
Reply
eacheson
7 - Meteor
‎04-10-2023 11:06 AM
Spoiler
eacheson_0-1681149957014.png

 

challenge_366_start_file.yxmd
Reply
0 Likes
ARussell34
8 - Asteroid
‎04-10-2023 11:16 AM

My solution!

 

ARussell34_0-1681150544757.png

 

AR_challenge366_sol.yxmd
Reply
0 Likes
mmontgomery
11 - Bolide
11 - Bolide
‎04-10-2023 11:30 AM

One long if-elseif statement

Spoiler
mmontgomery_0-1681151398132.png

 

c_366.yxzp
Reply
0 Likes
CharlotteGuy
8 - Asteroid
‎04-10-2023 11:30 AM
Spoiler
CharlotteGuy_0-1681151378150.png

 

challenge_366_start_file - Final Chris.yxmd
Reply
0 Likes
olga_strubbe
11 - Bolide
‎04-10-2023 12:48 PM
Spoiler
olga_strubbe_0-1681156057867.png

 

A fun and tricky challenge, thank you very much! 

Challenge 366_Three Columns are a Crowd.yxmd
Reply
0 Likes
TurboToad
10 - Fireball
‎04-10-2023 01:43 PM

Fun challenge! 

Spoiler
TurboToad_0-1681159379450.png

 

TT_challenge_366_solution_file.yxzp
Reply
0 Likes
Clifford_Coon
11 - Bolide
‎04-10-2023 02:05 PM

My Solution.

 

Could use one tool if you didn't want to drop extra columns.

Spoiler
solution_366.jpg

 
2 Ways regular formula and multi-field.  I prefer regular formula. :-)

challenge_366_start_file.yxmd
Reply
0 Likes
nagakavyasri
12 - Quasar
‎04-10-2023 02:12 PM
Spoiler
Used Single formula tool:

Screenshot 2023-04-10 171046.png
challenge_366_start_file.yxmd
Reply
0 Likes
CeliaC_Silje
8 - Asteroid
‎04-10-2023 07:00 PM
Spoiler
CeliaC_Silje_0-1681178421084.png
challenge_366_start_file.yxzp
Reply
0 Likes