Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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 #267: To Quote The Alphabet

rmassambane
10 - Fireball

Another one bites the dust!

jamielaird
14 - Magnetar

Here's my solution:

 

Spoiler
jamielaird_1-1624362189787.png
AndrewS
11 - Bolide

#267

Spoiler
267.PNG
mbogusz
9 - Comet
Spoiler
Challenge #267 in the canChallenge #267 in the can
glenperes
8 - Asteroid

Reminds me of Ascii function from my c programming days

Spoiler
Spoiler
267.JPG

RichoBsJ
11 - Bolide

Hi! Here my solution 🙂

dhavaldoshi
8 - Asteroid

How to do it as a Beginner?

I first thought of a transpose of all individual characters and use Multi-Row - So applied the same, check if the current character follows previous one in order, if yes increment the length and then a simple substring

 

Quite proud of my solution! 😄

Spoiler
Solution_267_macro.PNG

 

KaneG
Alteryx Alumni (Retired)

Nice and neat. Use of the tile to get the sequence and CharToInt in order to not need a lookup table

 

Spoiler
KaneG_0-1626245613194.png

 

Elias_Nordlinder
11 - Bolide

Interesting Challenge.
Had to read up on the Multi-Row formula tool a bit more.

 

Spoiler
Elias_Nordlinder_0-1626366831813.png

 

 

ywang7
7 - Meteor
Spoiler
ywang7_0-1626486108784.png