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

PrachiD
Asteroide

Regex, text to column, formula

Crichardson
Meteoroide

Challange 35

KorkuSep
Meteoro

This was fun cleaning data using multiple tool approach.

Spoiler
2023-04-11_15-37-20.jpg
Lenusa
Asteroide

my solution here.

siddharth_28
Asteroide

Re: Challenge #35: Data Cleansing Practice

Biplab19
Meteoro

Completed!

RachelBrinkley
Meteoroide

Here you go

nvijay5757
Meteoro

Data cleansing

HardikJani
Asteroide

Thanks for an easy one:) I used formula tool for the win. Used some standard formulae for all but the last. Used an If statement to get the last one.

mbit83
Meteoroide

Here is my solution