Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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 #458: Masking Alternating Characters

Janhavi_MS
5 - Atom

Attaching my solution

AkimasaKajitani
17 - Castor
17 - Castor

My solution!

 

Spoiler
image.png
alacoume
9 - Comet

My solution: 

Spoiler
Challenge_458.jpg
revac
6 - Meteoroid

Is it just me or the first character of 2nd row was also supposed to be "*"?

3I_ATLAS
9 - Comet

Phillip thanks for being the RegEx wizard as i see you leverage it to its full potential in whatever WC it may be applicable.  You're my inspiration to learn REGEX!  Thank you!

MikeBird
8 - Asteroid

I have attached my example workflow though I think in real word examples, I would have each row treated equally instead of first row having first character obscured and next row it being plain text. 

aatalai
15 - Aurora

C458

Spainey
9 - Comet

Fun challenge. 

 

Spoiler
I used the RecordID and Multi-Row Formula Tools to create multiple levels of IDs after transforming the data firstly to unique words per row, and then each letter on its own row. I used the Mod() function to identify every 2nd letter to obfuscate and then concatenated the letters back together, before concatenating the sentences back together ensuring spaces are included. 

Community Challenge 458 Solution.png

 

lisahitch95
8 - Asteroid

I think there was a mistake in the output where in row 1 the space was counted and in row 2 and 3 the space was not counted. My solution counts all the spaces.

Spoiler
Screenshot 2025-01-14 121540.png
Dhrish
8 - Asteroid

Solution