ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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 #35: Data Cleansing Practice

mackenzie_short
8 - Asteroid

still don't quite get regex tool, but getting better using the trim function within formula to get similar results

mnikolaeva
7 - Meteor

My Solution:

 

Spoiler
Capture d’écran (17).png

In the second one I've put 4 different options to remove text - just for fun 😁

SusieF
7 - Meteor
Spoiler
35 spoiler.PNG
MilindG
12 - Quasar
Spoiler
MilindG_0-1658843803074.png

 

Nadia_Bonner
8 - Asteroid
Spoiler
Nadia_Bonner_0-1658946012002.png

 

martinding
13 - Pulsar

WeChat Screenshot_20220730113045.png

Wanhope
8 - Asteroid
Spoiler
solution

Challenge 35 Solution.png

Brian32
8 - Asteroid

Challenge Solution:

Spoiler
Brian32_0-1659456571914.png

 

jrobiso2
8 - Asteroid

Done in 10

KalpanaM
7 - Meteor

KalpanaM_0-1660235689074.png

KalpanaM_1-1660235709747.png

KalpanaM_2-1660235733857.pngKalpanaM_3-1660235757210.png