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

k2rausch
6 - Meteoroid

Challenge #35

ankit1282
7 - Meteor

my sol

LH2021
5 - Atom

My solution.

mbearde1
5 - Atom

Weekly Challenge

caitlynle11
8 - Asteroid

Here is my solution to the challenge above;

1. Remove leading zeros using IIF:

caitlynle11_0-1650263658537.png

2. Trim leading zeroes and/or descriptive text at the end using RegEx

caitlynle11_1-1650263708998.png

3. Remove ID:

caitlynle11_2-1650263739874.png

4. Remove & replace characters based on the length of strings:

caitlynle11_3-1650263800109.png

 

 

iceincup
7 - Meteor

Here is my solution.

madhulikaverma9
6 - Meteoroid

Done

TonyAndriani
9 - Comet

Reposting under my new user ID.

bold3d
8 - Asteroid

my solution

PhilippBrinckmann
Alteryx Alumni (Retired)

my solution