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

jfha97
7 - Meteor
Spoiler
jfha97_0-1685735572959.png

 

caltang
17 - Castor
17 - Castor

I learned something new today! CharFromInt is so useful!

 

Spoiler
caltang_0-1685932348221.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Chunxin
5 - Atom

 

Spoiler
Chunxin_0-1685986705570.png

 

 

Try the solution @dsandmann provided, which is very concise and easy to understand. https://community.alteryx.com/t5/user/viewprofilepage/user-id/277938

DataNath
17 - Castor

My solution to #372.

 

Spoiler
DataNath_0-1685987275989.png
john-sundblom
5 - Atom

Here is my solution, learned about "Field Info" and CharFromInt formula to solve this one.

CammyPhillips
8 - Asteroid
Spoiler
CammyPhillips_0-1686215620696.png

 

Computernerd
8 - Asteroid

I struggled on this one.

Computernerd
8 - Asteroid

That's how I did mine initially. After revisions I did it in three regular formulas,

MattBenj
9 - Comet

My solution.

jacobcarman
8 - Asteroid
Spoiler
jacobcarman_0-1686336559288.png

 

Not too bad if you know the right tool to start with.