Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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