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