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 #372: A Header Reference Dataset from Excel Header Reference Letters

ErikStroem
6 - Meteoroid
‎05-25-2023 06:13 AM

Probably not the fastet way to solve it. But it did the job. 

Challenge_372_ES.yxmd
Reply
GiovanniCarignato
5 - Atom
‎05-25-2023 07:32 AM

Nice one!

Challenge_372_start_file_Giovanni.yxmd
Reply
kytes_
5 - Atom
‎05-25-2023 07:39 AM

Great!

Challenge_372_start_file_kytes_.yxmd
Reply
TurboToad
10 - Fireball
‎05-25-2023 08:00 AM

My solution.

 

Spoiler
TurboToad_0-1685026778492.png

 

TT_Challenge_372_solution_file.yxmd
Reply
Isabella_Venturini
7 - Meteor
‎05-26-2023 03:48 AM
Spoiler
Isabella_Venturini_0-1685098064414.png

 

Challenge_372_start_file_solved.yxmd
Reply
Isabella_Venturini
7 - Meteor
‎05-26-2023 04:13 AM
Spoiler
Isabella_Venturini_0-1685099552531.png

 

Challenge_372_start_file_solved_just_headers.yxmd
Reply
JereJussila
8 - Asteroid
‎05-26-2023 04:21 AM
Spoiler
JereJussila_1-1685100019097.png

 


 

View my solution !

Challenge_372_solution_JJ.yxzp
Reply
mg46
8 - Asteroid
‎05-26-2023 10:03 AM

 

Spoiler
mguarniere_0-1685120536751.png

 

Challenge_372_Michelle_G.yxzp
Reply
logdog0411
9 - Comet
‎05-26-2023 12:08 PM
Spoiler
logdog0411_0-1685127928981.png

 

I had a VERY complicated answer where I used a Text input and a Union to create a data row, then pivoted into column to create the letter string. 

 

Then I checked someone's spoiler and remembered the Field Info tool. I had never used it before. 

 

Now other than the Formulas (Which I showed in the screenshot), it's pretty simple. 

 

This was a creative and different challenge!

Challenge_372_Bellamy.yxzp
Reply
logdog0411
9 - Comet
‎05-26-2023 12:18 PM

Would just like to point out that I was trying to work on this challenge yesterday at the Solutions Center at Inspire, but had soooo many people come to ask questions that I could make no headway. Best distraction ever! 

 

@gptacek 

@TanushreeArora 

@kingrum 

Marc Oliver

@mariam_khalid 

@kev_hinds 

 

(some of these are guesses... thanks for livening up my afternoon!)

 

Reply