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

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
458.jpg
Tofel
9 - Comet
Spoiler
I wonder, if there is a way to do it in regex using only one tool.

Challenge 458.jpg

griffinwelsh
12 - Quasar

My solution

KLTerrell
8 - Asteroid

I'm working through this and am almost there, I love this challenge! But before I keep going I wanted to see if I could get clarification on the output. The 2nd row of the output (masking Alteryx Designer) starts masking at the 2nd character instead of the first, whereas the first and third rows start masking at the 1st character like the instructions indicate. Should the 1st character always be masked? Or is there a pattern I'm missing?

 

Thanks!

Katie

alexnajm
18 - Pollux
18 - Pollux

@KLTerrell I see - yes the first character should be always masked but clearly the answer output then would be wrong! So if you want to match the output exactly, you can consider the strings as continuous

KLTerrell
8 - Asteroid

Hmm. Okay, I am doing that - but I'm treating each row as its own string (so not considering a space between Abinajm and Alteryx). I will reconfigure my workflow to consider the rows as a continuous string.

 

Thanks!

Pilsner
13 - Pulsar

My solution:

Spoiler
458.png

Took me a little while to realise the letter ID should not be reset every new line (record) and instead should only be rest at a space. Great challenge! 

BransonJamesFarley
8 - Asteroid

Fun Challenge! 

Spoiler
458.PNG

Hub119
11 - Bolide
11 - Bolide

Sample solution doesn't appear to follow the naming convention rules for the second record... solution attached making the first character of each word start with an asterisk.

Spoiler
Challenge 458 Pic.png
KLTerrell
8 - Asteroid

Alright! This was fun. I decided to stick with the convention of re-starting the masking pattern with each string. (It's not beautiful, but it's done!)

 

Spoiler
Alteryx Challenge 458 - 2.png