Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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

DataGuy_V2
6 - Meteoroid

First solution is attached. Have a great day!

 

Summary:

Spoiler
Formula > Replace Char (using double quotes to specify single quotes and vice-versa)
Text-to-columns
Date Conversion
Select appropriate fields
Timi8
7 - Meteor

My Solution

Oren_Soloman
8 - Asteroid

Challenge Submission

matada
6 - Meteoroid

Solution

AliAS2020
8 - Asteroid

Hello all,

 

This is an update to my previous solution, in this one I used 3 methods to practice as much tools as possible as you can see in the attached image and yxzp.

 

Using a mix of Text to Column, RegEx and Formula tools.

 

 

 

Spoiler
Final Workflow.JPG

 

 

jiteshthegenius
7 - Meteor

SPOILER

jiteshthegenius_0-1591445398993.png

 

dpatnaik97
7 - Meteor

Attached the solution for challenge 2.

AnnaMikhaylova
9 - Comet

That was fun!

sayooj
6 - Meteoroid

hi

try4dipen
5 - Atom

Here is my version of solution.