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