Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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 #2: Preparing Delimited Data

PeterYuan
7 - Meteor

My solution for Challenge 2

dhavaldoshi
8 - Asteroid

How to do it as a Beginner?

Things to learn:

Solution only using the Parse Tool Palette

  • Date/Time Parse: Custom function is my favourite part of this tool, helps you configure strings to any expected date format, no longer confusion between MM-DD and DD-MM
  • Text to Columns: (inner Chandler) COULD IT BE ANY EASIER?
  • RegEx: Meh, takes time to learn but best for replace given the constraint of using single tool palette
Spoiler
Solution_2.PNG
meghanarang
6 - Meteoroid

My first Alteryx workflow

stephen787
6 - Meteoroid

Done

JaquiObrien
6 - Meteoroid

couple of examples...

saeedsemrin
7 - Meteor

my attempt

jtoboyle
6 - Meteoroid
Spoiler
challenge_2_solution_jo.PNG
NathalieCP
6 - Meteoroid

🙂

Spoiler
NathalieCP_0-1617033799389.png

 

jegali
5 - Atom

It is fun to see the different solutions around. Here is mine.

AlexPeacock
8 - Asteroid

My Solution