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

ehuitron
6 - Meteoroid
Spoiler
challenge372_Spoiler.JPG
alacoume
8 - Asteroid

Interesting!

CeliaC_Silje
8 - Asteroid

Approach

1. Configure Input Data tool to get column names

2. Determine column grouping (as there are 2 column letters starting from 27th column)

3. Convert column number to letter

 

Spoiler
CeliaC_Silje_0-1684912015339.png
sparekh1
7 - Meteor

My Solution 1:
 - Used 'Field Info' tool from 'Developers' tab to get metadata of input tool for further use.

 

Spoiler
sparekh1_0-1684917392966.png

 My Solution 2:
 - Removed checkbox from input tool to inform that 1st row is data and not header to optimize workflow more:

Spoiler
sparekh1_0-1684920238523.png

 

ferg_smith
8 - Asteroid
Spoiler
ferg_smith_0-1684919647467.png

 

rmassambane
10 - Fireball

372!

619sandesh
5 - Atom

My Solution :-

Spoiler
619sandesh_1-1684932784298.png

 

fritz_mira
7 - Meteor

Here's mine

kelvin_law1
9 - Comet

Interesting challenge!!  Here is my solution:

 

Spoiler
kelvinlaw_0-1685000953375.png

 

 

 

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

Nice one:)

 

Spoiler
Sebastian_Chaieb2_0-1685003124275.png