In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
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

ehuitron
6 - Meteoroid
Spoiler
challenge372_Spoiler.JPG
alacoume
9 - Comet

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
6 - Meteoroid

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
11 - Bolide
11 - Bolide

Nice one:)

 

Spoiler
Sebastian_Chaieb2_0-1685003124275.png