We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #267: To Quote The Alphabet

rmassambane
8 - Asteroid

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
10 - Fireball

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
Alteryx

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