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
Meteoro
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
Átomo

 

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
Cástor

My solution to #372.

 

Spoiler
DataNath_0-1685987275989.png
john-sundblom
Átomo

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

CammyPhillips
Asteroide
Spoiler
CammyPhillips_0-1686215620696.png

 

Computernerd
Asteroide

I struggled on this one.

Computernerd
Asteroide

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

MattBenj
Cometa

My solution.

jacobcarman
Asteroide
Spoiler
jacobcarman_0-1686336559288.png

 

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