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