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.
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

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 #257: Palindromes

Blake
12 - Quasar

A man a plan a canal panama

 

Spoiler
Blake_0-1614696657756.png

 

See below for a video walkthrough.

 

Spoiler
patrick_digan
16 - Nebula
16 - Nebula

It's also fun to use @jdunkerley79 's alteryx abacus variable functions. You can do so much more in the formula tool.

Spoiler
patrick_digan_2-1614611473827.png

 



patrick_digan_1-1614611416638.png

 

 

Maskell_Rascal
11 - Bolide

This was a fun one, and highlights a rarely used (at least by me) function of reversing strings. 

Spoiler
Maskell_Rascal_0-1614612923826.png

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1614613739835.png

 

Toons
11 - Bolide

My solution :

 

Spoiler
Toons_0-1614616166556.png

 

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
257.jpg
DeanWest
8 - Asteroid

racecar 🏎

 

Spoiler
challenge_257_solution_DeanWest-snippet.png

 

 

jamielaird
14 - Magnetar

That was good fun. Here's my solution:

 

Spoiler
jamielaird_0-1614621017308.png

 

jamielaird_1-1614621024329.png

 

phottovy
11 - Bolide

No macro needed:

Spoiler
257.PNG
MPard
6 - Meteoroid
Spoiler
MPard_1-1614624038819.png

I was able to parse the palindromes with a simple formula, after that filtering to get the data was a breeze!

The formula I used to detect palindromes is:
IF ((ReverseString(Right([Words], (length([Words]) - Mod(length([Words]), 2)/2)))) = (Left([Words], (length([Words]) - Mod(length([Words]), 2)/2)))) THEN 1 ELSE 0 ENDIF

This formula takes the last half of the word (excluding one character for odd length words), flips it, and compares it to the first half of the word (excluding one character for odd length words). Awesome to see Modulo is available in the formula operation, super useful for dynamic formulas like this!