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

Bobbyt23
12 - Quasar

Well it seemed simple then couldn't work out how to add the letters.

Spoiler
Learnt the CharFromInt([ID]+64) function in this one. Really useful!!
aatalai
14 - Magnetar

C372

Supriya2203
8 - Asteroid

Using

  • Data Transformation
  • ASCII codes i.e. CharFromInt(64)= A
  • Divisor dividend concept for remainder calculations
mkeiffer
10 - Fireball
10 - Fireball

Here is my solution!

Spoiler
Screenshot 2024-08-09 at 12.21.03 PM.png

MelGibson
10 - Fireball
Spoiler
372.png


lwolfie
11 - Bolide

Got it

mgaronson
11 - Bolide
Spoiler
Challenge 372 Workflow Pic.png

 Mod function is key