Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

Vidya26
8 - Asteroid

My Solution

Garabujo7
Alteryx
Alteryx

Here's my solution, I think it could be improved and be more efficient but this one does the job.

Spoiler
Spoiler ahead

2019-06-06_15-13-08.png


2019-06-06_15-15-34.png

 

 


AntoineR1509
7 - Meteor

This is my solution for the Challenge 35 :)

RobertoEstrada
8 - Asteroid

My solution posted here

Inactive User
Not applicable

Solution attached, a few functions and some regex!

dillon_bok
8 - Asteroid
Spoiler
Weekly Challenge - 35.PNG
JeffS
Alteryx Alumni (Retired)

My solution attached

joshuaburkhow
ACE Emeritus
ACE Emeritus

Good reminder on a valuable function ;)

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
RWvanLeeuwen
11 - Bolide

Very straightforward if you know a few basic functions

 

Spoiler
35.png
gautamsawant93
7 - Meteor

Here's my solution, I have mostly used the formula tool.