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

olga_strubbe
11 - Bolide

Here is the workflow for my solution.  Sorry I forgot to include it right away :) 

Dabou460
7 - Meteor

Hello,

 

Here is my solution.

 

 

Spoiler
Capture.PNG

 

Thank you


David B

TimJVR
7 - Meteor
Spoiler
TimJVR_0-1684847248588.png

 

As always with comments for explanation.

MatteoReddavide
8 - Asteroid

Learned a lot thanks to this challenge!

 

Spoiler
MatteoReddavide_0-1684855120973.png

 

DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2023-05-24 013949.jpg

M__K__A
7 - Meteor

My solution includes mocking up the Excel Column Letters from an Excel file using some formulas, then importing that into Alteryx.  Perhaps there is a better way to solve for this in Alteryx alone, where the Column Letter sequence is generated automatically.  Anyhow, this is what I came up with and the output matches!

dougbaron
8 - Asteroid

took a bit to use minimal tools

Spoiler
dougbaron_0-1684866594138.png

 

PrinceAli64
6 - Meteoroid
Spoiler
PrinceAli64_0-1684868535380.png

 

mmontgomery
11 - Bolide

Tried to take a more programmatic approach to assigned columns/letters etc.

 

Spoiler
mmontgomery_0-1684872214567.png

 

Powerhouse_21
9 - Comet
Spoiler
Powerhouse_21_0-1684882084947.png