Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start 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.

 

スポイラ
Not beutiful...

AkimasaKajitani_0-1684781785044.png

 

rachel_lynch
Alteryx
Alteryx
スポイラ
rachel_lynch_0-1684785181539.png

 

Rachel Lynch
Clifford_Coon
ボリード

My Solution: 

スポイラ
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
コメット
スポイラ
Flo_P_0-1684787170212.png

 

annbriceAB
アステロイド

A fun challenge! Thanks!

ARussell34
アステロイド

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

 

ARussell34_0-1684792687202.png

 

AaronSmatta
アステロイド

Solution

François_Rs
アステロイド
スポイラ
Franois_Rs_0-1684826692173.png

 

Christina_H
マグネター

My solution

スポイラ
Christina_H_0-1684832130716.png

 

olga_strubbe
ボリード
スポイラ

olga_strubbe_1-1684844994845.png

 

A neat challenge, thank you, @caro_smith !