Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

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

Nice one!

kytes_
5 - Atom

Great!

TurboToad
10 - Fireball

My solution.

 

Spoiler
TurboToad_0-1685026778492.png

 

Isabella_Venturini
7 - Meteor
Spoiler
Isabella_Venturini_0-1685098064414.png

 

Isabella_Venturini
7 - Meteor
Spoiler
Isabella_Venturini_0-1685099552531.png

 

JereJussila
8 - Asteroid
Spoiler
JereJussila_1-1685100019097.png

 


 

View my solution !

mg46
8 - Asteroid

 

Spoiler
mguarniere_0-1685120536751.png

 

logdog0411
9 - Comet
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!

logdog0411
9 - Comet

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!)