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 #2: Preparing Delimited Data

noahsakr
7 - Meteor

My attempt at the solution! Not too bad of a challenge. 

AdrianMa
6 - Meteoroid

My solution

 

Spoiler
AdrianMa_0-1619319739245.png

 

 

eduardorusso
5 - Atom

First time posting here. Here's my solution to this challenge

SierraZizzo
7 - Meteor
Spoiler
SierraZizzo_0-1619494026957.png

 

EVH
6 - Meteoroid

My first solution! When possible, I try to use the built in Alteryx tools to get my desired results. First, I split the columns using the comma delimiter. Then I used the Date/Time tool with the Custom setting to get the date and have the metadata as a date. The Data Cleansing tool is awesome for removing punctuation, so that came next. As a best practice, I try to not rename fields until the end of a workflow (prevents confusing joins and blows up unions), so I kept the Select tool until the end...and there you have it!

 

solution.jpg

bandhakaviarun
6 - Meteoroid

Here is my soution.

MarkJackson
8 - Asteroid
Spoiler
MarkJackson_0-1619789226479.png

 

frank6773
8 - Asteroid

Here is my solution.

jasonXaristides
7 - Meteor

my solution

meghanarang
6 - Meteoroid

My submission