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

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
Not beutiful...

AkimasaKajitani_0-1684781785044.png

 

rachel_lynch
Alteryx
Alteryx
Spoiler
rachel_lynch_0-1684785181539.png

 

Rachel Lynch
Clifford_Coon
11 - Bolide

My Solution: 

Spoiler
challenge_372.jpg


Formula:
if (ceil([RecordID]/26) - 1) = 0
THEN ""
ELSE charfromint((ceil([RecordID]/26) - 1) + 64)
ENDIF
+
if mod([RecordID],26) !=0
THEN charfromint(mod([RecordID],26) + 64)
ELSE charfromint(90)
ENDIF

Flo_P
9 - Comet
Spoiler
Flo_P_0-1684787170212.png

 

annbriceAB
8 - Asteroid

A fun challenge! Thanks!

ARussell34
8 - Asteroid

I took a bit of a round about way, but found the solution!

 

ARussell34_0-1684792687202.png

 

AaronSmatta
8 - Asteroid

Solution

François_Rs
8 - Asteroid
Spoiler
Franois_Rs_0-1684826692173.png

 

Christina_H
14 - Magnetar

My solution

Spoiler
Christina_H_0-1684832130716.png

 

olga_strubbe
11 - Bolide
Spoiler

olga_strubbe_1-1684844994845.png

 

A neat challenge, thank you, @caro_smith !